DBA Data[Home] [Help]

APPS.HR_DM_COPY dependencies on HR_DM_EXP_HR_LOC_ALL_V

Line 361: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_HR_LOC_ALL_V',15);

357: -- only perform for an FW migration
358:
359: if (l_migration_type = 'FW') then
360:
361: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_HR_LOC_ALL_V',15);
362: insert into HR_DM_EXP_HR_LOC_ALL_V (
363: EXP_IMP_ID,
364: TABLE_NAME,
365: LOCATION_ID,

Line 362: insert into HR_DM_EXP_HR_LOC_ALL_V (

358:
359: if (l_migration_type = 'FW') then
360:
361: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_HR_LOC_ALL_V',15);
362: insert into HR_DM_EXP_HR_LOC_ALL_V (
363: EXP_IMP_ID,
364: TABLE_NAME,
365: LOCATION_ID,
366: LOCATION_CODE,

Line 1511: from HR_DM_EXP_HR_LOC_ALL_V dmv

1507: ENTERED_BY,
1508: TP_HEADER_ID,
1509: ECE_TP_LOCATION_CODE,
1510: OBJECT_VERSION_NUMBER
1511: from HR_DM_EXP_HR_LOC_ALL_V dmv
1512: where not exists (select null
1513: from HR_LOCATIONS_ALL tb
1514: where dmv.location_id = tb.LOCATION_ID);
1515: