APPS.BEN_DM_INIT dependencies on BEN_DM_PHASES

Line 563: INSERT INTO ben_dm_phases (PHASE_ID,

559: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_p_table', 5);
560: ben_dm_utility.message('PARA','(r_migration_data - record' ||
561: ')(p_phase_name - ' || p_phase_name || ')', 10);
562:
563: INSERT INTO ben_dm_phases (PHASE_ID,
564: MIGRATION_ID,
565: PHASE_NAME,
566: STATUS,
567: START_TIME,

Line 574: SELECT ben_dm_phases_s.nextval,

570: CREATION_DATE,
571: LAST_UPDATED_BY,
572: LAST_UPDATE_DATE,
573: LAST_UPDATE_LOGIN)
574: SELECT ben_dm_phases_s.nextval,
575: r_migration_data.migration_id,
576: p_phase_name,
577: 'NS',
578: NULL,

Line 587: (SELECT NULL FROM ben_dm_phases

583: SYSDATE,
584: NULL
585: FROM dual
586: WHERE NOT EXISTS
587: (SELECT NULL FROM ben_dm_phases
588: WHERE ((migration_id = r_migration_data.migration_id)
589: AND (phase_name = p_phase_name)));
590:
591: COMMIT;