DBA Data[Home] [Help]

APPS.PAY_CN_EXT dependencies on PAY_PAYROLL_ACTIONS

Line 2627: , pay_payroll_actions ppa

2623: IS
2624: --
2625: SELECT max(paa.assignment_action_id)
2626: FROM pay_assignment_actions paa
2627: , pay_payroll_actions ppa
2628: , per_all_assignments_f paf
2629: WHERE paa.payroll_action_id = ppa.payroll_action_id
2630: AND paf.assignment_id = p_assignment_id
2631: AND paf.assignment_id = paa.assignment_id

Line 2651: , pay_payroll_actions ppa

2647: IS
2648: --
2649: SELECT ppa.date_earned
2650: FROM pay_assignment_actions paa
2651: , pay_payroll_actions ppa
2652: WHERE paa.assignment_action_id = p_assg_act_id
2653: AND paa.payroll_action_id = ppa.payroll_action_id;
2654:
2655: --

Line 3074: , pay_payroll_actions ppa

3070: ,p_end_date IN DATE)
3071: IS
3072: SELECT max(paa.assignment_action_id)
3073: FROM pay_assignment_actions paa
3074: , pay_payroll_actions ppa
3075: , per_all_assignments_f paf
3076: WHERE paa.payroll_action_id = ppa.payroll_action_id
3077: AND paf.assignment_id = p_assignment_id
3078: AND paf.assignment_id = paa.assignment_id