APPS.HRI_OPL_GEO_LOCHR dependencies on HRI_DBI_CS_GEO_REGION_V

Line 465: FROM hri_dbi_cs_geo_region_v csr

461: , csr.geo_region_sk_pk
462: , csr.start_date
463: , csr.end_date
464: , csr.last_change_date
465: FROM hri_dbi_cs_geo_region_v csr
466: WHERE csr.geo_region_sk_pk = tbl.geo_region_sk_pk
467: AND ( csr.geo_area_code <> tbl.geo_area_code
468: OR csr.geo_country_code <> tbl.geo_country_code
469: OR csr.start_date <> tbl.start_date

Line 475: FROM hri_dbi_cs_geo_region_v csr

471: )
472: )
473: WHERE EXISTS
474: (SELECT 'X'
475: FROM hri_dbi_cs_geo_region_v csr
476: WHERE csr.geo_region_sk_pk = tbl.geo_region_sk_pk
477: AND ( csr.geo_area_code <> tbl.geo_area_code
478: OR csr.geo_country_code <> tbl.geo_country_code
479: OR csr.start_date <> tbl.start_date

Line 498: FROM hri_dbi_cs_geo_region_v csr

494: DELETE
495: FROM hri_cs_geo_region_ct tbl
496: WHERE NOT EXISTS
497: (SELECT 'X'
498: FROM hri_dbi_cs_geo_region_v csr
499: WHERE csr.geo_region_sk_pk = tbl.geo_region_sk_pk
500: )
501: ;
502: dbg_time('Delete End');

Line 529: FROM hri_dbi_cs_geo_region_v csr

525: , csr.geo_region_sk_pk
526: , csr.start_date
527: , csr.end_date
528: , csr.last_change_date
529: FROM hri_dbi_cs_geo_region_v csr
530: WHERE NOT EXISTS
531: (SELECT 'x'
532: FROM hri_cs_geo_region_ct tbl
533: WHERE csr.geo_region_sk_pk = tbl.geo_region_sk_pk

Line 844: FROM hri_dbi_cs_geo_region_v csr

840: , g_user_id CREATED_BY
841: , g_current_time LAST_UPDADTE_DATE
842: , g_user_id LAST_UPDATE_BY
843: , g_user_id LAST_UPDATE_LOGIN
844: FROM hri_dbi_cs_geo_region_v csr
845: ;
846: dbg_time('Insert End');
847: --
848: -- @@Code specific to this view/table below ENDS