APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on PO_LOCATION_ASSOCIATIONS_ALL

Line 2971: t_address_id po_location_associations_all.address_id%TYPE;

2967: t_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
2968: t_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2969: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
2970: t_status hz_cust_site_uses_all.status%TYPE;
2971: t_address_id po_location_associations_all.address_id%TYPE;
2972: t_site_loc_id hr_locations.location_id%TYPE;
2973: t_orig_system_reference hz_locations.orig_system_reference%TYPE;
2974: t_last_update_date DATE;
2975: t_party_site_last_update_date DATE;

Line 5293: FROM po_location_associations_all

5289: AND c_acct_site.org_id = l_org_id;
5290:
5291: CURSOR invloc_check_cur IS
5292: SELECT location_id
5293: FROM po_location_associations_all
5294: WHERE site_use_id = l_site_use_id;
5295:
5296: /* CURSOR po_loc_assoc_exists_cur IS
5297: SELECT location_id

Line 5298: FROM po_location_Associations_all

5294: WHERE site_use_id = l_site_use_id;
5295:
5296: /* CURSOR po_loc_assoc_exists_cur IS
5297: SELECT location_id
5298: FROM po_location_Associations_all
5299: WHERE location_id = l_inv_location_id;
5300: */
5301:
5302: CURSOR address_cur IS