DBA Data[Home] [Help]

APPS.AHL_UTILITY_PVT dependencies on HR_ORGANIZATION_UNITS

Line 684: FROM HR_ORGANIZATION_UNITS hou

680: -- Cursor for getting organization id out of org name
681: CURSOR get_org_id_csr(p_org_name IN VARCHAR2)
682: IS
683: SELECT hou.organization_id
684: FROM HR_ORGANIZATION_UNITS hou
685: WHERE hou.name = p_org_name;
686:
687: --Cursor for checking if the given organization belongs to user's OU.
688: -- SATHAPLI::Bug# 5246136 fix

Line 693: FROM HR_ORGANIZATION_UNITS hou,

689: -- Changed reference of ORG_ORGANIZATION_DEFINITIONS to INV_ORGANIZATION_INFO_V
690: CURSOR is_user_in_ou_csr(p_org_id IN NUMBER)
691: IS
692: SELECT hou.organization_id
693: FROM HR_ORGANIZATION_UNITS hou,
694: MTL_PARAMETERS mtl
695: WHERE
696: hou.organization_id IN (
697: SELECT organization_id