DBA Data[Home] [Help]

APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_PAYROLL_ACTIONS

Line 743: ,pay_payroll_actions ppa

739: IS
740: SELECT /*+ leading(paa) */
741: DISTINCT (ptp.end_date) end_date
742: FROM pay_assignment_actions paa
743: ,pay_payroll_actions ppa
744: ,per_time_periods ptp
745: WHERE ptp.time_period_id = ppa.time_period_id
746: AND ppa.payroll_action_id = paa.payroll_action_id
747: AND ppa.effective_date BETWEEN p_effective_start_date AND p_effective_end_date