APPS.HZ_IMP_LOAD_POST_PROCESS_PKG dependencies on HZ_GEO_NAME_REFERENCES

Line 719: AND exists (select 1 from hz_geo_name_references gnr

715: AND site_sg.int_row_id = site_int.rowid
716: AND site_int.correct_move_indicator = 'C'
717: AND site_int.interface_status IS NULL /* check if any validation error */
718: AND site_sg.party_site_id = ps.party_site_id
719: AND exists (select 1 from hz_geo_name_references gnr
720: where gnr.location_id = ps.location_id
721: and gnr.location_table_name = 'HZ_LOCATIONS');
722:
723: l_msg_count NUMBER;