Section 17-Done
GROUP BY
BG.PAYRUN_ID,
BG.PAYSHEET_ID,
BG.PAY_PERIOD_ID,
BG.PAYRUN_NAME,
BG.PAY_DATE,
BG.CREDITED_PARTICIPANT_ID,
BG.ORG_ID,
BG.PAY_GROUP_NAME,
BG.LATEST_HOME_CURRENCY,
BG.PAYSHEET_STATUS,
BG.conversionrate,
BG.finalPayout,
BG.finalPayout_paysheet,
BG.PAY_AMT_PAY_CURR_USD,
PN.person_number,
PN.PARTICIPANT_NAME,
LPC.PLAN_COMPONENT_ID,
LPC.PLAN_COMPONENT_name,
LPC.INCENTIVE_TYPE,
LPC.ROLE_NAME,
PAY_CAL.PAYSHEET_CUTOFF_DT,
PAY_CAL.MPA_CUTOFF_START_DT,
PAY_CAL.MPA_CUTOFF_END_DT,
PAY_CAL.PAYROLL_SUBMISSION_END_CST,
parDetails.COUNTRY_CODE,
parDetails.ANALYST_PARTY_ID,
parDetails.PD_HR_TI,
DUAL_SNAP.HRStatus_c,
DUAL_SNAP.SalesRP_c,
DUAL_SNAP.EmploymentCountry_c,
DUAL_SNAP.PAY_DATE,
DUAL_SNAP.PAYSHEET_CUTOFF_DT,
MC_FLAGS.BBMultiCurrencyFlag,
MC_FLAGS.MULTI_CURR_YN,
BB_AMT.BB_IN_LATEST_HC,
BB_AMT.BB_IN_USD,
BB_AMT.BB_HOME_CURRENCIES,
BB_AMT.BB_BREAKDOWN_BY_CURRENCY,
BB_AMT.OLD_PAY_PERIOD_IDS,
PTD_AMT.PTD_EARNINGS_LC,
PTD_AMT.PTD_EARNINGS_USD,
PM_TI.Prorated_MonthlyTI
) base
) rules;
Comments
Post a Comment