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

Popular posts from this blog

Section 16-Done

Section 13-Done