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

Popular posts from this blog

Section 15-Done

Section 16-Done

Section 13-Done