APPS.ZX_SRVC_TYP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 7954: l_org_name HR_ALL_ORGANIZATION_UNITS.NAME%TYPE; --Bug 10179680

7950: l_tax_prof_id NUMBER;
7951: l_partytype VARCHAR2(100);
7952: l_context_info_rec ZX_API_PUB.context_info_rec_type;
7953: l_item_name MTL_SYSTEM_ITEMS_B.SEGMENT1%TYPE; --Bug 10179680
7954: l_org_name HR_ALL_ORGANIZATION_UNITS.NAME%TYPE; --Bug 10179680
7955:
7956: BEGIN
7957: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7958: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');

Line 8492: FROM HR_ALL_ORGANIZATION_UNITS HAOU

8488:
8489: BEGIN
8490: SELECT HAOU.NAME ORG_NAME
8491: INTO L_ORG_NAME
8492: FROM HR_ALL_ORGANIZATION_UNITS HAOU
8493: WHERE HAOU.ORGANIZATION_ID=ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.product_org_id(p_trx_line_index);
8494:
8495: EXCEPTION
8496: WHEN OTHERS THEN