DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_PAYROLL_ACTIONS

Line 1920: FROM pay_assignment_actions paa, pay_payroll_actions ppa

1916: ),
1917: 16
1918: )
1919: )
1920: FROM pay_assignment_actions paa, pay_payroll_actions ppa
1921: WHERE paa.assignment_id = c_assignment_id
1922: AND ppa.payroll_action_id = paa.payroll_action_id
1923: AND paa.source_action_id IS NOT NULL
1924: AND ppa.effective_date <= c_effective_date

Line 4832: pay_payroll_actions ppa,

4828: )
4829: IS
4830: SELECT DISTINCT (ptp.end_date) end_date
4831: FROM per_time_periods ptp,
4832: pay_payroll_actions ppa,
4833: pay_assignment_actions paa
4834: WHERE ptp.time_period_id = ppa.time_period_id
4835: AND ppa.effective_date BETWEEN ptp.start_date
4836: AND ptp.end_date