APPS.PA_CUSTOMERS_CONTACTS_UTILS dependencies on PA_CUSTOMER_SITES_V

Line 256: FROM pa_customer_sites_v

252:
253:
254: CURSOR c_ids IS
255: SELECT address_id
256: FROM pa_customer_sites_v
257: WHERE upper(address1) = upper(p_bill_site_name) AND
258: customer_id = p_customer_id AND
259: site_use_code = 'BILL_TO';
260:

Line 266: FROM pa_customer_sites_v

262: if (p_bill_to_address_id = FND_API.G_MISS_NUM) OR (p_bill_to_address_id is NULL) then
263: if (p_bill_site_name is not NULL) then
264: SELECT address_id
265: INTO x_bill_to_address_id
266: FROM pa_customer_sites_v
267: WHERE upper(address1) = upper(p_bill_site_name) AND
268: customer_id = p_customer_id AND
269: site_use_code = 'BILL_TO';
270: else

Line 277: FROM pa_customer_sites_v

273: else
274: if p_check_id_flag = 'Y' then
275: SELECT address_id
276: INTO x_bill_to_address_id
277: FROM pa_customer_sites_v
278: WHERE address_id = p_bill_to_address_id AND
279: customer_id = p_customer_id AND
280: site_use_code = 'BILL_TO';
281: ELSIF (p_check_id_flag='N') THEN

Line 368: FROM pa_customer_sites_v

364:
365:
366: CURSOR c_ids IS
367: SELECT address_id
368: FROM pa_customer_sites_v
369: WHERE upper(address1) = upper(p_work_site_name) AND
370: customer_id = p_customer_id AND
371: site_use_code = 'SHIP_TO';
372: BEGIN

Line 377: FROM pa_customer_sites_v

373: if (p_ship_to_address_id = FND_API.G_MISS_NUM) OR (p_ship_to_address_id is NULL) then
374: if (p_work_site_name is not NULL) then
375: SELECT address_id
376: INTO x_ship_to_address_id
377: FROM pa_customer_sites_v
378: WHERE upper(address1) = upper(p_work_site_name) AND
379: customer_id = p_customer_id AND
380: site_use_code = 'SHIP_TO';
381: else

Line 389: FROM pa_customer_sites_v

385: else
386: if p_check_id_flag = 'Y' then
387: SELECT address_id
388: INTO x_ship_to_address_id
389: FROM pa_customer_sites_v
390: WHERE address_id = p_ship_to_address_id AND
391: customer_id = p_customer_id AND
392: site_use_code = 'SHIP_TO';
393: