APPS.PAY_POPULATION_RANGES_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 29: FROM PAY_ASSIGNMENT_ACTIONS ACT

25: into l_dummy
26: FROM SYS.DUAL
27: WHERE EXISTS (
28: SELECT NULL
29: FROM PAY_ASSIGNMENT_ACTIONS ACT
30: WHERE ACT.PAYROLL_ACTION_ID = p_payroll_action_id)
31: OR EXISTS (
32: SELECT NULL
33: FROM PAY_MESSAGE_LINES PML

Line 655: from pay_assignment_actions aa

651: forall i in 1..l_pay_act_tab.count
652: delete from pay_action_interlocks pai
653: where pai.locking_action_id in
654: (select aa.assignment_action_id
655: from pay_assignment_actions aa
656: where payroll_action_id = l_pay_act_tab(i)
657: and chunk_number = l_chunk_num_tab(i));
658: --
659: forall i in 1..l_pay_act_tab.count

Line 660: delete from pay_assignment_actions aa

656: where payroll_action_id = l_pay_act_tab(i)
657: and chunk_number = l_chunk_num_tab(i));
658: --
659: forall i in 1..l_pay_act_tab.count
660: delete from pay_assignment_actions aa
661: where aa.payroll_action_id = l_pay_act_tab(i)
662: and aa.chunk_number = l_chunk_num_tab(i);
663: --
664: forall i in 1..l_pay_act_tab.count