DBA Data[Home] [Help]

APPS.PAY_RETRO_NOTIF_PKG dependencies on DUAL

Line 227: FROM dual;

223: p_payroll_id in number) is
224: --
225: cursor c_sequence is
226: SELECT hr_assignment_sets_s.nextval
227: FROM dual;
228: --
229: l_rowid VARCHAR2(30);
230: l_asg_set_id NUMBER;
231: --

Line 1372: -- This run_asg_adv_retronot is called at an individual assignment level

1368: end process_action;
1369: --
1370: -- populate_adv_retro_tables is called from the RetroNotification Report ENh
1371: -- and is executed at Payroll level
1372: -- This run_asg_adv_retronot is called at an individual assignment level
1373: -- from the Automated RetroPay Solution
1374: procedure run_asg_adv_retronot(
1375: p_assignment_id in number,
1376: p_business_group_id in number,

Line 1615: FROM dual;

1611: for asgrec in c_actions_range_on(pactid, chunk) loop
1612: --
1613: SELECT pay_assignment_actions_s.nextval
1614: INTO lockingactid
1615: FROM dual;
1616: --
1617: -- insert the action record.
1618: hr_nonrun_asact.insact(lockingactid,asgrec.assignment_id,pactid,chunk, null);
1619: --

Line 1632: FROM dual;

1628: for asgrec in c_actions(pactid, stperson, endperson) loop
1629: --
1630: SELECT pay_assignment_actions_s.nextval
1631: INTO lockingactid
1632: FROM dual;
1633: --
1634: -- insert the action record.
1635: hr_nonrun_asact.insact(lockingactid,asgrec.assignment_id,pactid,chunk, null);
1636: --