APPS.HZ_LOCATION_V2PUB dependencies on HZ_PARTY_SITES

Line 840: FROM hz_party_sites hps

836: l_party_id NUMBER;
837:
838: CURSOR c1 IS
839: SELECT hps.party_id
840: FROM hz_party_sites hps
841: WHERE hps.location_id = p_location_rec.location_id
842: AND hps.identifying_address_flag = 'Y';
843: BEGIN
844: IF (p_location_rec.country IS NOT NULL AND

Line 1440: FROM hz_party_sites

1436: ) IS
1437:
1438: CURSOR c_standalone_location IS
1439: SELECT 1
1440: FROM hz_party_sites
1441: WHERE location_id = p_location_rec.location_id
1442: AND status NOT IN ('M', 'D')
1443: AND ROWNUM = 1;
1444:

Line 2303: FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps,

2299: )
2300: IS
2301: Cursor c_locations(p_location_id NUMBER) IS
2302: SELECT ac.CUST_ACCT_SITE_ID
2303: FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps,
2304: HZ_CUST_ACCT_SITES_ALL ac
2305: WHERE loc.LOCATION_ID=p_location_id
2306: AND loc.LOCATION_ID = ps.LOCATION_ID
2307: AND ps.PARTY_SITE_ID=ac.PARTY_SITE_ID;