APPS.HR_DM_LIBRARY dependencies on DUAL

Line 2346: from dual

2342: hr_dm_upload.g_data_migrator_source_db,
2343: p_table_name,
2344: p_source_id,
2345: p_destination_id
2346: from dual
2347: where not exists (select null
2348: from hr_dm_resolve_pks
2349: where source_database_instance =
2350: hr_dm_upload.g_data_migrator_source_db

Line 3289: from dual

3285: ,'CREATED_BY'
3286: ,l_created_table
3287: ,'CREATED_NAME'
3288: ,'USER_NAME_ID'
3289: from dual
3290: where not exists (select 'x'
3291: from hr_dm_hierarchies hir
3292: where hir.hierarchy_type = 'A'
3293: and hir.table_id = l_table_id

Line 3318: from dual

3314: ,'LAST_UPDATED_BY'
3315: ,l_updated_table
3316: ,'UPDATED_NAME'
3317: ,'USER_NAME_ID'
3318: from dual
3319: where not exists (select 'x'
3320: from hr_dm_hierarchies hir
3321: where hir.hierarchy_type = 'A'
3322: and hir.table_id = l_table_id

Line 3428: from dual

3424: ,'REQUEST_ID'
3425: ,NULL
3426: ,NULL
3427: ,NULL
3428: from dual
3429: where not exists (select 'x'
3430: from hr_dm_hierarchies hir
3431: where hir.hierarchy_type = 'N'
3432: and hir.table_id = l_table_id

Line 3453: from dual

3449: ,'PROGRAM_APPLICATION_ID'
3450: ,NULL
3451: ,NULL
3452: ,NULL
3453: from dual
3454: where not exists (select 'x'
3455: from hr_dm_hierarchies hir
3456: where hir.hierarchy_type = 'N'
3457: and hir.table_id = l_table_id