DBA Data[Home] [Help]

APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_PAYROLL_ACTIONS

Line 1921: FROM pay_assignment_actions paa, pay_payroll_actions ppa

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

Line 4833: pay_payroll_actions ppa,

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