APPS.HZ_LOCATION_SERVICES_PUB dependencies on AR_LOOKUPS

Line 202: FROM ar_lookups

198: -- the higher the code, the poor the data.
199: -- e.g: 0 means validated successfully
200: CURSOR get_maxmin_scode IS
201: SELECT max(to_number(lookup_code)), min(to_number(lookup_code))
202: FROM ar_lookups
203: WHERE lookup_type = 'HZ_ADDR_VAL_STATUS'
204: AND enabled_flag = 'Y';
205:
206: -- get adapter_id base on adapter_content_source

Line 672: from AR_LOOKUPS

668: l_party_id NUMBER;
669:
670: CURSOR get_highest_score IS
671: select max(to_number(lookup_code))
672: from AR_LOOKUPS
673: where lookup_type = 'HZ_ADDR_VAL_STATUS';
674:
675: CURSOR get_loc_obj_version_number(l_location_id NUMBER) IS
676: select object_version_number, state, province, country,