APPS.INV_LABEL_PVT8 dependencies on HZ_GEO_STRUCT_MAP

Line 522: FROM hz_geo_struct_map map

518: --AND NVL ( acct_site.org_id, -99 ) = NVL ( loc_assign.org_id, -99 ) --13683119
519: --start of 13683119
520: AND DECODE ( NVL(
521: (SELECT 1
522: FROM hz_geo_struct_map map
523: WHERE map.country_code = loc.country
524: AND map.loc_tbl_name = 'HZ_LOCATIONS'
525: AND rownum = 1
526: ), 0), 1, NVL(