DBA Data[Home] [Help]

APPS.HR_DM_COPY dependencies on HR_DM_EXP_HR_LOC_ALL_TL_V

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

542: -- use dynamic sql to avoid compiliation errors where the data pump views
543: -- have not yet been created
544: execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL';
545:
546: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_HR_LOC_ALL_TL_V',15);
547: insert into HR_DM_EXP_HR_LOC_ALL_TL_V (
548: EXP_IMP_ID,
549: TABLE_NAME,
550: LOCATION_ID,

Line 547: insert into HR_DM_EXP_HR_LOC_ALL_TL_V (

543: -- have not yet been created
544: execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL';
545:
546: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_HR_LOC_ALL_TL_V',15);
547: insert into HR_DM_EXP_HR_LOC_ALL_TL_V (
548: EXP_IMP_ID,
549: TABLE_NAME,
550: LOCATION_ID,
551: LANGUAGE,

Line 1538: from HR_DM_EXP_HR_LOC_ALL_TL_V dmv

1534: LAST_UPDATED_BY,
1535: LAST_UPDATE_LOGIN,
1536: CREATED_BY,
1537: to_date(creation_date,'YYYYMMDD HH24:MI:SS')
1538: from HR_DM_EXP_HR_LOC_ALL_TL_V dmv
1539: where not exists (select null
1540: from HR_LOCATIONS_ALL_TL tb
1541: where dmv.location_id = tb.LOCATION_ID);
1542: