APPS.PAY_IN_PF_ARCHIVE dependencies on DUAL

Line 438: -- It then archives individual balances. --

434: -- It also gets the element entries for the element --
435: -- 'PF Refund Information' and the Vol PF Percentage --
436: -- 'EE Voluntary PF Percent'. --
437: -- --
438: -- It then archives individual balances. --
439: -- --
440: -- Parameters : --
441: -- IN : p_run_asg_action_id NUMBER --
442: -- p_arc_asg_action_id NUMBER --

Line 1692: FROM dual;

1688: FOR csr_rec IN csr_process_supp_assignments(rec_reg_return.bus_no)
1689: LOOP
1690: SELECT pay_assignment_actions_s.NEXTVAL
1691: INTO l_action_id
1692: FROM dual;
1693:
1694: IF g_debug THEN
1695: pay_in_utils.trace('l_action_id : ',l_action_id);
1696: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);

Line 1765: FROM dual;

1761: FOR csr_rec IN csr_process_rev_assignments(rec_reg_return.bus_no)
1762: LOOP
1763: SELECT pay_assignment_actions_s.NEXTVAL
1764: INTO l_action_id
1765: FROM dual;
1766:
1767: IF g_debug THEN
1768: pay_in_utils.trace('l_action_id : ',l_action_id);
1769: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);

Line 1815: FROM dual;

1811: LOOP
1812:
1813: SELECT pay_assignment_actions_s.NEXTVAL
1814: INTO l_action_id
1815: FROM dual;
1816:
1817: IF g_debug THEN
1818: pay_in_utils.trace('l_action_id : ',l_action_id);
1819: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);