APPS.HR_DM_INIT dependencies on DUAL

Line 298: FROM dual

294: SYSDATE,
295: 1,
296: SYSDATE,
297: NULL
298: FROM dual
299: WHERE NOT EXISTS
300: (SELECT NULL FROM hr_dm_phase_items
301: WHERE ((phase_id = l_phase_id)
302: AND (table_name = l_table_name)));

Line 408: FROM dual

404: SYSDATE,
405: 1,
406: SYSDATE,
407: NULL
408: FROM dual
409: WHERE NOT EXISTS
410: (SELECT NULL FROM hr_dm_phase_items
411: WHERE ((phase_id = l_phase_id)
412: AND (table_name = l_table_name)));

Line 544: FROM dual;

540:
541: -- get phase_item_ids for ua and da phases
542: SELECT HR_DM_PHASE_ITEMS_S.nextval
543: INTO l_phase_item_id_da
544: FROM dual;
545: SELECT HR_DM_PHASE_ITEMS_S.nextval
546: INTO l_phase_item_id_ua
547: FROM dual;
548: -- hr_dm_phase_items da phase

Line 547: FROM dual;

543: INTO l_phase_item_id_da
544: FROM dual;
545: SELECT HR_DM_PHASE_ITEMS_S.nextval
546: INTO l_phase_item_id_ua
547: FROM dual;
548: -- hr_dm_phase_items da phase
549: INSERT INTO hr_dm_phase_items (PHASE_ITEM_ID,
550: PHASE_ID,
551: LOADER_NAME,

Line 569: FROM dual;

565: NULL,
566: 'NS',
567: NULL,
568: NULL
569: FROM dual;
570: -- hr_dm_phase_items da phase
571: INSERT INTO hr_dm_phase_items (PHASE_ITEM_ID,
572: PHASE_ID,
573: LOADER_NAME,

Line 591: FROM dual;

587: NULL,
588: 'NS',
589: NULL,
590: NULL
591: FROM dual;
592:
593: -- generate filename
594: l_filename := get_filename(l_phase_item_id_da,
595: p_param_rec.loader_conc_program);

Line 640: FROM dual;

636: p_param_rec.parameter8,
637: p_param_rec.parameter9,
638: p_param_rec.parameter10,
639: p_custom_code_specified
640: FROM dual;
641:
642: COMMIT;
643:
644: hr_dm_utility.message('INFO','Seeded UA/DA phase item', 15);

Line 1290: FROM dual

1286: SYSDATE,
1287: 1,
1288: SYSDATE,
1289: NULL
1290: FROM dual
1291: WHERE NOT EXISTS
1292: (SELECT NULL FROM hr_dm_phase_items
1293: WHERE ((phase_id = l_phase_id)
1294: AND (batch_id = l_batch_id)

Line 1490: FROM dual

1486: SYSDATE,
1487: 1,
1488: SYSDATE,
1489: NULL
1490: FROM dual
1491: WHERE NOT EXISTS
1492: (SELECT NULL FROM hr_dm_phase_items
1493: WHERE ((phase_id = l_phase_id)
1494: AND (batch_id = l_batch_id)

Line 1710: FROM dual

1706: SYSDATE,
1707: 1,
1708: SYSDATE,
1709: NULL
1710: FROM dual
1711: WHERE NOT EXISTS
1712: (SELECT NULL FROM hr_dm_phase_items
1713: WHERE ((phase_id = l_phase_id)
1714: AND (group_id = l_group_id)));

Line 1833: FROM dual

1829: SYSDATE,
1830: 1,
1831: SYSDATE,
1832: NULL
1833: FROM dual
1834: WHERE NOT EXISTS
1835: (SELECT NULL FROM hr_dm_phase_items
1836: WHERE ((phase_id = l_phase_id)
1837: AND (loader_name = l_loader_name)));

Line 2063: FROM dual

2059: SYSDATE,
2060: 1,
2061: SYSDATE,
2062: NULL
2063: FROM dual
2064: WHERE NOT EXISTS
2065: (SELECT NULL FROM hr_dm_phases
2066: WHERE ((migration_id = r_migration_data.migration_id)
2067: AND (phase_name = p_phase_name)));