DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PAY_PAYROLL_ACTIONS

Line 2613: from pay_payroll_actions ps

2609: into p_del_flag
2610: from sys.dual
2611: where exists
2612: (select null
2613: from pay_payroll_actions ps
2614: , pay_assignment_actions aa
2615: where aa.assignment_id = P_ASSIGNMENT_ID
2616: and ps.payroll_action_id = aa.payroll_action_id
2617: and ps.action_type not in ('X','BEE') --Added for bug2956160

Line 2632: from pay_payroll_actions ps

2628: into p_del_flag
2629: from dual
2630: where exists
2631: (select null
2632: from pay_payroll_actions ps
2633: , pay_assignment_actions aa
2634: where aa.assignment_id = P_ASSIGNMENT_ID
2635: and ps.action_type not in ('X','BEE') --Added for bug2956160
2636: and ps.payroll_action_id = aa.payroll_action_id);

Line 2648: from pay_payroll_actions ps

2644: into p_del_flag
2645: from sys.dual
2646: where exists
2647: (select null
2648: from pay_payroll_actions ps
2649: , pay_assignment_actions aa
2650: where aa.assignment_id = P_ASSIGNMENT_ID
2651: and ps.payroll_action_id = aa.payroll_action_id
2652: and ps.action_type not in ('X','BEE') --Added for bug2956160