APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 882: FROM hr_all_organization_units

878: IF (party_rec.party_role_code = 'INTERNAL_ORG')
879: THEN
880: SELECT name
881: INTO l_party_name
882: FROM hr_all_organization_units
883: WHERE organization_id = party_rec.party_id;
884:
885: -- b. Else If the party_role_code==SUPPLIER_ORG
886: -- get the party name from po_vendors using party_id join.