APPS.MST_AGG_PKG dependencies on WSH_LOCATIONS

Line 5797: from wsh_locations loc

5793: begin
5794:
5795: select location_source_code
5796: into l_location_source_code
5797: from wsh_locations loc
5798: where loc.wsh_location_id = p_location_id;
5799: -- including both customer and carrier, don't care it's customer/carrier
5800: if l_location_source_code = 'HZ' then
5801: select hzp.party_name

Line 5861: from wsh_locations loc

5857: begin
5858:
5859: select location_source_code
5860: into l_location_source_code
5861: from wsh_locations loc
5862: where loc.wsh_location_id = p_location_id;
5863: -- including both customer and carrier, don't care it's customer/carrier
5864: if l_location_source_code = 'HZ' then
5865: fetch customer_account into l_owner_name;

Line 5927: from wsh_locations loc

5923: begin
5924:
5925: select location_source_code
5926: into l_location_source_code
5927: from wsh_locations loc
5928: where loc.wsh_location_id = p_location_id;
5929: -- including both customer and carrier, don't care it's customer/carrier
5930: if l_location_source_code = 'HZ' then
5931: fetch customer_account into l_owner_name;