APPS.ZX_SRVC_TYP_PKG dependencies on HZ_LOCATIONS

Line 4979: ELSIF p_table = 'HZ_LOCATIONS' THEN

4975: l_ptnr_addr_tbl(l_add_idx).address3,
4976: l_ptnr_addr_tbl(l_add_idx).address4
4977: FROM HR_LOCATIONS_ALL
4978: WHERE location_id = p_location_id;
4979: ELSIF p_table = 'HZ_LOCATIONS' THEN
4980: SELECT address1, address2, address3, address4
4981: INTO l_ptnr_addr_tbl(l_add_idx).address1,
4982: l_ptnr_addr_tbl(l_add_idx).address2,
4983: l_ptnr_addr_tbl(l_add_idx).address3,

Line 4985: FROM HZ_LOCATIONS

4981: INTO l_ptnr_addr_tbl(l_add_idx).address1,
4982: l_ptnr_addr_tbl(l_add_idx).address2,
4983: l_ptnr_addr_tbl(l_add_idx).address3,
4984: l_ptnr_addr_tbl(l_add_idx).address4
4985: FROM HZ_LOCATIONS
4986: WHERE location_id = p_location_id;
4987: ELSIF p_table = 'PO_VENDOR_SITES_ALL' THEN
4988: SELECT address1, address2, address3, address4
4989: INTO l_ptnr_addr_tbl(l_add_idx).address1,

Line 4993: FROM HZ_LOCATIONS

4989: INTO l_ptnr_addr_tbl(l_add_idx).address1,
4990: l_ptnr_addr_tbl(l_add_idx).address2,
4991: l_ptnr_addr_tbl(l_add_idx).address3,
4992: l_ptnr_addr_tbl(l_add_idx).address4
4993: FROM HZ_LOCATIONS
4994: WHERE location_id = p_location_id;
4995: END IF;
4996: END IF;
4997: x_address1 := l_ptnr_addr_tbl(l_add_idx).address1;