APPS.HRI_OPL_GEO_LOCHR dependencies on HRI_CS_GEO_LOCHR_V

Line 253: FROM hri_cs_geo_lochr_v svw

249: effective_start_date,
250: effective_end_date,
251: business_group_id,
252: NVL(last_change_date, g_dbi_collection_start_date)
253: FROM hri_cs_geo_lochr_v svw
254: --
255: -- 4303724, Used TRUNC function
256: --
257: WHERE TRUNC(last_change_date) BETWEEN g_start_date

Line 315: FROM hri_cs_geo_lochr_v svw

311: svw.effective_start_date,
312: svw.effective_end_date,
313: svw.business_group_id,
314: NVL(svw.last_change_date, g_dbi_collection_start_date)
315: FROM hri_cs_geo_lochr_v svw
316: WHERE svw.location_id = tbl.location_id
317: AND ( svw.area_code <> tbl.area_code
318: OR svw.country_code <> tbl.country_code
319: OR svw.region_code <> tbl.region_code

Line 325: FROM hri_cs_geo_lochr_v svw

321: )
322: )
323: WHERE EXISTS
324: (SELECT 'X'
325: FROM hri_cs_geo_lochr_v svw
326: WHERE svw.location_id = tbl.location_id
327: AND svw.effective_start_date = tbl.effective_start_date
328: AND svw.effective_end_date = tbl.effective_end_date
329: AND ( svw.area_code <> tbl.area_code

Line 350: FROM hri_cs_geo_lochr_v svw

346: DELETE
347: FROM hri_cs_geo_lochr_ct tbl
348: WHERE NOT EXISTS
349: (SELECT 'x'
350: FROM hri_cs_geo_lochr_v svw
351: WHERE svw.location_id = tbl.location_id
352: )
353: ;
354: dbg_time('Delete End');

Line 764: FROM hri_cs_geo_lochr_v svw

760: g_user_id,
761: g_user_id,
762: g_user_id,
763: g_current_time
764: FROM hri_cs_geo_lochr_v svw
765: ;
766: dbg_time('Insert End');
767: --
768: -- @@Code specific to this view/table below ENDS