Section 15-Done
-- BB as % of HR TI
TO_CHAR(
CASE
WHEN NVL(parDetails.PD_HR_TI, 0) = 0 THEN 0
ELSE (
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
) / parDetails.PD_HR_TI
) * 100
END,
'FM9999999990.00'
) AS BBOfHRTI_c,
-- Paysheet Status
BG.PAYSHEET_STATUS AS PaysheetStatus_c,
-- Conversion Rate
BG.conversionrate AS ConversionRate_c,
-- Paysheet Payout (Local Currency)
BG.finalPayout_paysheet AS PaysheetPayoutLC_c,
-- Additional debugging/tracking fields
TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS') AS QueryExecutionTime_c,
-- Snapshot dates for debugging
TO_CHAR(DUAL_SNAP.PAY_DATE, 'YYYY-MM-DD') AS SnapshotPayDate_c,
TO_CHAR(DUAL_SNAP.PAYSHEET_CUTOFF_DT, 'YYYY-MM-DD') AS SnapshotCutoffDate_c
Comments
Post a Comment