APPS.ZX_SRVC_TYP_PKG dependencies on HR_LOCATIONS_ALL

Line 5798: IF p_table = 'HR_LOCATIONS_ALL' THEN

5794: IF (NOT(l_ptnr_addr_tbl.EXISTS(l_add_idx))) THEN
5795: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5796: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Caching from database for '||l_add_idx);
5797: END IF;
5798: IF p_table = 'HR_LOCATIONS_ALL' THEN
5799: SELECT address_line_1, address_line_2, address_line_3, NULL
5800: INTO l_ptnr_addr_tbl(l_add_idx).address1,
5801: l_ptnr_addr_tbl(l_add_idx).address2,
5802: l_ptnr_addr_tbl(l_add_idx).address3,

Line 5804: FROM HR_LOCATIONS_ALL

5800: INTO l_ptnr_addr_tbl(l_add_idx).address1,
5801: l_ptnr_addr_tbl(l_add_idx).address2,
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,