eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1307: -- This run_asg_adv_retronot is called at an individual assignment level

1303: end process_action;
1304: --
1305: -- populate_adv_retro_tables is called from the RetroNotification Report ENh
1306: -- and is executed at Payroll level
1307: -- This run_asg_adv_retronot is called at an individual assignment level
1308: -- from the Automated RetroPay Solution
1309: procedure run_asg_adv_retronot(
1310: p_assignment_id in number,
1311: p_business_group_id in number,

Line 1550: FROM dual;

1546: for asgrec in c_actions_range_on(pactid, chunk) loop
1547: --
1548: SELECT pay_assignment_actions_s.nextval
1549: INTO lockingactid
1550: FROM dual;
1551: --
1552: -- insert the action record.
1553: hr_nonrun_asact.insact(lockingactid,asgrec.assignment_id,pactid,chunk, null);
1554: --

Line 1567: FROM dual;

1563: for asgrec in c_actions(pactid, stperson, endperson) loop
1564: --
1565: SELECT pay_assignment_actions_s.nextval
1566: INTO lockingactid
1567: FROM dual;
1568: --
1569: -- insert the action record.
1570: hr_nonrun_asact.insact(lockingactid,asgrec.assignment_id,pactid,chunk, null);
1571: --