DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT dependencies on PAY_PAYROLL_ACTIONS

Line 2650: from pay_payroll_actions ps

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

Line 2669: from pay_payroll_actions ps

2665: into p_del_flag
2666: from dual
2667: where exists
2668: (select null
2669: from pay_payroll_actions ps
2670: , pay_assignment_actions aa
2671: where aa.assignment_id = P_ASSIGNMENT_ID
2672: and ps.action_type not in ('X','BEE') --Added for bug2956160
2673: and ps.payroll_action_id = aa.payroll_action_id);

Line 2685: from pay_payroll_actions ps

2681: into p_del_flag
2682: from sys.dual
2683: where exists
2684: (select null
2685: from pay_payroll_actions ps
2686: , pay_assignment_actions aa
2687: where aa.assignment_id = P_ASSIGNMENT_ID
2688: and ps.payroll_action_id = aa.payroll_action_id
2689: and ps.action_type not in ('X','BEE') --Added for bug2956160