APPS.PO_MOAC_UTILS_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 589: l_ou_short_code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION5%TYPE;

585: p_org_id IN NUMBER
586: )
587: RETURN VARCHAR2
588: IS
589: l_ou_short_code HR_ORGANIZATION_INFORMATION.ORG_INFORMATION5%TYPE;
590: l_progress VARCHAR2(3) := NULL;
591: BEGIN
592:
593: l_progress := '010';

Line 596: FROM HR_ORGANIZATION_INFORMATION HROI

592:
593: l_progress := '010';
594: SELECT HROI.ORG_INFORMATION5
595: INTO l_ou_short_code
596: FROM HR_ORGANIZATION_INFORMATION HROI
597: WHERE HROI.ORGANIZATION_ID = p_org_id
598: AND HROI.ORG_INFORMATION_CONTEXT = 'Operating Unit Information';
599:
600: l_progress := '020';