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
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);
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