APPS.PAY_US_PSD_UPGRADE_PKG dependencies on DUAL

Line 236: FROM DUAL;

232: 'PSDUPGRADE_'||to_char(sysdate,'DDMONYYYYHHMISS'),
233: TRUNC(sysdate),
234: 'P'
235: INTO l_id,l_patch_name,l_date,l_status
236: FROM DUAL;
237:
238: INSERT INTO pay_patch_status
239: (id,patch_number,patch_name,phase,status,applied_date,legislation_code,description)
240: VALUES

Line 333: FROM DUAL;

329: 'PSDUPGRADE_'||to_char(sysdate,'DDMONYYYYHHMISS'),
330: TRUNC(sysdate),
331: 'P'
332: INTO l_id,l_patch_name,l_date,l_status
333: FROM DUAL;
334:
335: INSERT INTO pay_patch_status
336: (id,patch_number,patch_name,phase,status,applied_date,legislation_code,description)
337: VALUES

Line 366: FROM DUAL;

362: /*Create the Element set for Elements having Jurisdiction Code as Input Value*/
363:
364: SELECT pay_element_sets_s.nextval
365: INTO l_element_set_id
366: FROM DUAL;
367:
368: INSERT INTO pay_element_sets
369: (element_set_id,
370: legislation_code,

Line 1352: FROM DUAL;

1348: LOOP
1349:
1350: SELECT pay_assignment_actions_s.nextval
1351: INTO l_locking_action_id
1352: FROM DUAL;
1353:
1354: hr_nonrun_asact.insact(lockingactid => l_locking_action_id,
1355: object_Id => l_assignment_id,
1356: pactid => pactid,

Line 1386: FROM DUAL;

1382: LOOP
1383:
1384: SELECT pay_assignment_actions_s.nextval
1385: INTO l_locking_action_id
1386: FROM DUAL;
1387:
1388: hr_nonrun_asact.insact(lockingactid => l_locking_action_id,
1389: object_Id => l_assignment_id,
1390: pactid => pactid,