APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_LOCATIONS

Line 1318: HZ_LOCATIONS l

1314:
1315: CURSOR dupcheck IS
1316: SELECT PARTY_SITE_ID
1317: FROM HZ_PARTY_SITES ps,
1318: HZ_LOCATIONS l
1319: WHERE ps.party_id = p_to_fk_id
1320: AND ps.location_id = l.location_id
1321: AND (ps.status IS NULL OR ps.status = 'A')
1322: AND UPPER(TRIM(ADDRESS1) ||

Line 1342: FROM HZ_LOCATIONS

1338: TRIM(CITY) ||
1339: TRIM(PROVINCE) ||
1340: TRIM(COUNTY) ||
1341: TRIM(POSTAL_CODE))
1342: FROM HZ_LOCATIONS
1343: WHERE LOCATION_ID = p_from_location_id);
1344:
1345: l_record_id NUMBER;
1346: BEGIN