APPS.HZ_MATCH_RULE_61 dependencies on HZ_LOCATIONS

Line 5741: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5737: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5738: ) IS
5739: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5740: SELECT party_site_id
5741: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5742: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5743: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5744:
5745: I NUMBER;

Line 5743: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

5739: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5740: SELECT party_site_id
5741: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5742: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5743: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5744:
5745: I NUMBER;
5746: J NUMBER:=1;
5747: l_party_site_id NUMBER;