APPS.ZX_SRVC_TYP_PKG dependencies on HZ_LOCATIONS

Line 5806: ELSIF p_table = 'HZ_LOCATIONS' THEN

5802: l_ptnr_addr_tbl(l_add_idx).address3,
5803: l_ptnr_addr_tbl(l_add_idx).address4
5804: FROM HR_LOCATIONS_ALL
5805: WHERE location_id = p_location_id;
5806: ELSIF p_table = 'HZ_LOCATIONS' THEN
5807: SELECT address1, address2, address3, address4
5808: INTO l_ptnr_addr_tbl(l_add_idx).address1,
5809: l_ptnr_addr_tbl(l_add_idx).address2,
5810: l_ptnr_addr_tbl(l_add_idx).address3,

Line 5812: FROM HZ_LOCATIONS

5808: INTO l_ptnr_addr_tbl(l_add_idx).address1,
5809: l_ptnr_addr_tbl(l_add_idx).address2,
5810: l_ptnr_addr_tbl(l_add_idx).address3,
5811: l_ptnr_addr_tbl(l_add_idx).address4
5812: FROM HZ_LOCATIONS
5813: WHERE location_id = p_location_id;
5814: ELSIF p_table = 'PO_VENDOR_SITES_ALL' THEN
5815: SELECT address1, address2, address3, address4
5816: INTO l_ptnr_addr_tbl(l_add_idx).address1,

Line 5820: FROM HZ_LOCATIONS

5816: INTO l_ptnr_addr_tbl(l_add_idx).address1,
5817: l_ptnr_addr_tbl(l_add_idx).address2,
5818: l_ptnr_addr_tbl(l_add_idx).address3,
5819: l_ptnr_addr_tbl(l_add_idx).address4
5820: FROM HZ_LOCATIONS
5821: WHERE location_id = p_location_id;
5822: END IF;
5823: END IF;
5824: x_address1 := l_ptnr_addr_tbl(l_add_idx).address1;