APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on PO_LOCATION_ASSOCIATIONS_ALL

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 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