APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on PO_LOCATION_ASSOCIATIONS

Line 2465: t_address_id po_location_associations_all.address_id%TYPE;

2461: t_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
2462: t_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2463: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
2464: t_status hz_cust_site_uses_all.status%TYPE;
2465: t_address_id po_location_associations_all.address_id%TYPE;
2466: t_site_loc_id hr_locations.location_id%TYPE;
2467: t_orig_system_reference hz_locations.orig_system_reference%TYPE;
2468: t_last_update_date DATE;
2469: t_party_site_last_update_date DATE;

Line 2575: from po_location_associations p, hz_locations z, hz_cust_acct_sites c, hz_party_sites ps

2571: c.translated_customer_name,
2572: c.last_update_date,
2573: ps.last_update_date,
2574: z.last_update_date
2575: from po_location_associations p, hz_locations z, hz_cust_acct_sites c, hz_party_sites ps
2576: where p.address_id = c.cust_acct_site_id and c.party_site_id = ps.party_site_id and ps.location_id = z.location_id and p.location_id = l_inv_location_id;
2577:
2578: CURSOR l_inv_loc_csr IS
2579: select address_line_1, address_line_2, address_line_3, town_or_city, country, postal_code, region_1, region_2, region_3, attribute_category,

Line 4431: FROM po_location_associations_all

4427: AND c_acct_site.org_id = l_org_id;
4428:
4429: CURSOR invloc_check_cur IS
4430: SELECT location_id
4431: FROM po_location_associations_all
4432: WHERE site_use_id = l_site_use_id;
4433:
4434: /* CURSOR po_loc_assoc_exists_cur IS
4435: SELECT location_id

Line 4436: FROM po_location_Associations_all

4432: WHERE site_use_id = l_site_use_id;
4433:
4434: /* CURSOR po_loc_assoc_exists_cur IS
4435: SELECT location_id
4436: FROM po_location_Associations_all
4437: WHERE location_id = l_inv_location_id;
4438: */
4439:
4440: CURSOR address_cur IS