APPS.HZ_LOCATION_SERVICES_PUB dependencies on HZ_PARTY_SITES

Line 704: FROM hz_party_sites hps

700:
701: -- check if location has been used as identifying address
702: CURSOR ident_address(l_location_id NUMBER) IS
703: SELECT hps.party_id
704: FROM hz_party_sites hps
705: WHERE hps.location_id = l_location_id
706: AND hps.identifying_address_flag = 'Y';
707:
708: BEGIN

Line 968: FROM HZ_PARTY_SITES ps

964: SET cas.address_text = null
965: WHERE cas.address_text IS NOT NULL
966: AND EXISTS
967: ( SELECT 1
968: FROM HZ_PARTY_SITES ps
969: WHERE ps.location_id = l_location_rec.location_id
970: AND cas.party_site_id = ps.party_site_id );
971:
972: -- denormalize location if it has been used as identifying address

Line 1186: FROM HZ_PARTY_SITES PS

1182: SELECT 'Y'
1183: INTO l_is_remit_to_location
1184: FROM DUAL
1185: WHERE EXISTS ( SELECT 1
1186: FROM HZ_PARTY_SITES PS
1187: WHERE PS.LOCATION_ID = l_location_rec.location_id
1188: AND PS.PARTY_ID = -1);
1189: EXCEPTION
1190: WHEN NO_DATA_FOUND THEN