APPS.ZX_SRVC_TYP_PKG dependencies on HR_LOCATIONS_ALL

Line 4971: IF p_table = 'HR_LOCATIONS_ALL' THEN

4967: IF (NOT(l_ptnr_addr_tbl.EXISTS(l_add_idx))) THEN
4968: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4969: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Caching from database for '||l_add_idx);
4970: END IF;
4971: IF p_table = 'HR_LOCATIONS_ALL' THEN
4972: SELECT address_line_1, address_line_2, address_line_3, NULL
4973: INTO l_ptnr_addr_tbl(l_add_idx).address1,
4974: l_ptnr_addr_tbl(l_add_idx).address2,
4975: l_ptnr_addr_tbl(l_add_idx).address3,

Line 4977: FROM HR_LOCATIONS_ALL

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