APPS.HZ_LOCATION_V2PUB dependencies on HZ_PARTY_SITES

Line 827: FROM hz_party_sites hps

823: l_party_id NUMBER;
824:
825: CURSOR c1 IS
826: SELECT hps.party_id
827: FROM hz_party_sites hps
828: WHERE hps.location_id = p_location_rec.location_id
829: AND hps.identifying_address_flag = 'Y';
830: BEGIN
831: IF (p_location_rec.country IS NOT NULL AND

Line 1427: FROM hz_party_sites

1423: ) IS
1424:
1425: CURSOR c_standalone_location IS
1426: SELECT 1
1427: FROM hz_party_sites
1428: WHERE location_id = p_location_rec.location_id
1429: AND status NOT IN ('M', 'D')
1430: AND ROWNUM = 1;
1431:

Line 2271: FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps,

2267: )
2268: IS
2269: Cursor c_locations(p_location_id NUMBER) IS
2270: SELECT ac.CUST_ACCT_SITE_ID
2271: FROM HZ_LOCATIONS loc, HZ_PARTY_SITES ps,
2272: HZ_CUST_ACCT_SITES_ALL ac
2273: WHERE loc.LOCATION_ID=p_location_id
2274: AND loc.LOCATION_ID = ps.LOCATION_ID
2275: AND ps.PARTY_SITE_ID=ac.PARTY_SITE_ID;