APPS.HZ_CUST_ACCOUNT_ROLE_V2PUB dependencies on HZ_PARTY_SITES

Line 162: l_party_site_number HZ_PARTY_SITES.party_site_number%TYPE;

158:
159: l_party_site_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_REC_TYPE;
160: l_location_id NUMBER;
161: l_party_site_id NUMBER;
162: l_party_site_number HZ_PARTY_SITES.party_site_number%TYPE;
163: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
164:
165: BEGIN
166:

Line 196: FROM HZ_PARTY_SITES

192: p_cust_account_role_rec.cust_acct_site_id <> FND_API.G_MISS_NUM
193: THEN
194: -- select location id
195: SELECT LOCATION_ID INTO l_location_id
196: FROM HZ_PARTY_SITES
197: WHERE PARTY_SITE_ID = (
198: SELECT PARTY_SITE_ID
199: FROM HZ_CUST_ACCT_SITES
200: WHERE CUST_ACCT_SITE_ID = p_cust_account_role_rec.cust_acct_site_id );

Line 205: FROM HZ_PARTY_SITES

201:
202: -- check if the address has been used by the party
203: BEGIN
204: SELECT 'Y' INTO l_dummy
205: FROM HZ_PARTY_SITES
206: WHERE PARTY_ID = p_cust_account_role_rec.party_id
207: AND LOCATION_ID = l_location_id;
208: EXCEPTION
209: WHEN NO_DATA_FOUND THEN