APPS.PAY_IN_PF_ARCHIVE dependencies on DUAL

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

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

Line 1696: FROM dual;

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

Line 1769: FROM dual;

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

Line 1819: FROM dual;

1815: LOOP
1816:
1817: SELECT pay_assignment_actions_s.NEXTVAL
1818: INTO l_action_id
1819: FROM dual;
1820:
1821: IF g_debug THEN
1822: pay_in_utils.trace('l_action_id : ',l_action_id);
1823: pay_in_utils.trace('csr_rec.assignment_id : ',csr_rec.assignment_id);