DBA Data[Home] [Help]

APPS.BEN_DM_INIT dependencies on DUAL

Line 171: FROM dual

167: SYSDATE,
168: 1,
169: SYSDATE,
170: NULL
171: FROM dual
172: WHERE NOT EXISTS
173: (SELECT NULL FROM ben_dm_phase_items
174: WHERE ((phase_id = l_phase_id)
175: AND (table_name = l_table_name)));

Line 276: FROM dual

272: SYSDATE,
273: 1,
274: SYSDATE,
275: NULL
276: FROM dual
277: WHERE NOT EXISTS
278: (SELECT NULL FROM ben_dm_phase_items
279: WHERE ((phase_id = l_phase_id)
280: AND (input_file_id = l_input_file_id)));

Line 377: FROM dual

373: SYSDATE,
374: 1,
375: SYSDATE,
376: NULL
377: FROM dual
378: WHERE NOT EXISTS
379: (SELECT NULL FROM ben_dm_phase_items
380: WHERE ((phase_id = l_phase_id)
381: AND (group_order = l_group_order)));

Line 585: FROM dual

581: SYSDATE,
582: 1,
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)));