APPS.PO_CUSTOMERS_SV dependencies on PO_LOCATION_ASSOCIATIONS

Line 28: FROM po_location_associations_all pola,

24: pola.site_use_id
25: INTO x_customer_id,
26: x_address_id,
27: x_site_use_id
28: FROM po_location_associations_all pola,
29: org_organization_definitions org
30: WHERE pola.location_id = x_deliver_to_location_id
31: AND org.organization_id= x_source_org_id -- bug 5028505
32: AND org.operating_unit= pola.org_id; -- bug 5028505

Line 41: FROM po_location_associations pola

37: pola.site_use_id
38: INTO x_customer_id,
39: x_address_id,
40: x_site_use_id
41: FROM po_location_associations pola
42: WHERE pola.location_id = x_deliver_to_location_id;
43: end if;
44:
45: EXCEPTION