APPS.HRI_OPL_GEO_LOCHR dependencies on HRI_DBI_CS_GEO_COUNTRY_V

Line 597: FROM hri_dbi_cs_geo_country_v csc

593: , csc.geo_country_code
594: , csc.start_date
595: , csc.end_date
596: , csc.last_change_date
597: FROM hri_dbi_cs_geo_country_v csc
598: WHERE csc.geo_country_code = tbl.geo_country_code
599: AND ( csc.geo_area_code <> tbl.geo_area_code
600: OR csc.start_date <> tbl.start_date
601: OR csc.end_date <> tbl.end_date

Line 606: FROM hri_dbi_cs_geo_country_v csc

602: )
603: )
604: WHERE EXISTS
605: (SELECT 'X'
606: FROM hri_dbi_cs_geo_country_v csc
607: WHERE csc.geo_country_code = tbl.geo_country_code
608: AND ( csc.geo_area_code <> tbl.geo_area_code
609: OR csc.start_date <> tbl.start_date
610: OR csc.end_date <> tbl.end_date

Line 631: FROM hri_dbi_cs_geo_country_v csc

627: DELETE
628: FROM hri_cs_geo_country_ct tbl
629: WHERE NOT EXISTS
630: (SELECT 'x'
631: FROM hri_dbi_cs_geo_country_v csc
632: WHERE csc.geo_country_code = tbl.geo_country_code
633: )
634: ;
635: dbg_time('Delete End');

Line 661: FROM hri_dbi_cs_geo_country_v csc

657: , csc.geo_country_code
658: , csc.start_date
659: , csc.end_date
660: , csc.last_change_date
661: FROM hri_dbi_cs_geo_country_v csc
662: WHERE NOT EXISTS
663: (SELECT 'x'
664: FROM hri_cs_geo_country_ct tbl
665: WHERE csc.geo_country_code = tbl.geo_country_code

Line 920: FROM hri_dbi_cs_geo_country_v csc

916: , g_user_id CREATED_BY
917: , g_current_time LAST_UPDATE_DATE
918: , g_user_id LAST_UPDATED_BY
919: , g_user_id LAST_UPDATE_LOGIN
920: FROM hri_dbi_cs_geo_country_v csc
921: ;
922: dbg_time('Insert End');
923: --
924: -- @@Code specific to this view/table below ENDS