Section 14-Done

-- PTD Earnings (Period-to-Date) CASE WHEN MC_FLAGS.MULTI_CURR_YN = 'Y' THEN PTD_AMT.PTD_EARNINGS_LC ELSE BG.finalPayout END AS PTDEarnings_c, -- PTD Earnings in USD CASE WHEN MC_FLAGS.MULTI_CURR_YN = 'Y' THEN TO_CHAR(PTD_AMT.PTD_EARNINGS_USD, 'FM9999999990.0000') ELSE TO_CHAR(BG.PAY_AMT_PAY_CURR_USD, 'FM9999999990.0000') END AS PTDEarningsUSD_c, -- Period Multi-Currency Flag NVL(MC_FLAGS.MULTI_CURR_YN, 'N') AS PeriodMultiCurrencyFlag_c, -- Current Earnings Distribution (CED) = PTD - BB TO_CHAR( TO_NUMBER( CASE WHEN MC_FLAGS.MULTI_CURR_YN = 'Y' THEN PTD_AMT.PTD_EARNINGS_LC ELSE BG.finalPayout END ) - TO_NUMBER( CASE WHEN MC_FLAGS.BBMultiCurrencyFlag = 'Y' THEN BB_AMT.BB_IN_LATEST_HC ELSE TO_CHAR( NVL( SUM( CASE WHEN BP.PAY_PERIOD_ID <> BP.PAY_DATE THEN BP.PAY_AMT_PAY_CURR ELSE 0 END ), 0 ), 'FM9999999990.0000' ) END ), 'FM9999999990.0000' ) AS CED_c, -- CED in USD TO_CHAR( TO_NUMBER( CASE WHEN MC_FLAGS.MULTI_CURR_YN = 'Y' THEN TO_CHAR(PTD_AMT.PTD_EARNINGS_USD, 'FM9999999990.0000') ELSE TO_CHAR(BG.PAY_AMT_PAY_CURR_USD, 'FM9999999990.0000') END ) - TO_NUMBER( CASE WHEN MC_FLAGS.BBMultiCurrencyFlag = 'Y' THEN BB_AMT.BB_IN_USD ELSE TO_CHAR( NVL( SUM( CASE WHEN BP.PAY_PERIOD_ID <> BP.PAY_DATE THEN BP.PAY_AMT_PAY_CURR * NVL( (CASE WHEN BP.HOME_CURRENCY_CODE = 'USD' THEN 1 ELSE CR_USD.CONVERSION_RATE END), 1 ) ELSE 0 END ), 0 ), 'FM9999999990.0000' ) END ), 'FM9999999990.0000' ) AS CEDUSD_c,

Comments

Popular posts from this blog

Section 15-Done

Section 16-Done

Section 13-Done