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
Post a Comment