DBA Data[Home] [Help]

APPS.AHL_UTILITY_PVT dependencies on INV_ORGANIZATION_INFO_V

Line 689: -- Changed reference of ORG_ORGANIZATION_DEFINITIONS to INV_ORGANIZATION_INFO_V

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
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,

Line 698: FROM INV_ORGANIZATION_INFO_V

694: MTL_PARAMETERS mtl
695: WHERE
696: hou.organization_id IN (
697: SELECT organization_id
698: FROM INV_ORGANIZATION_INFO_V
699:
700: WHERE NVL(operating_unit, mo_global.get_current_org_id()) =
701: mo_global.get_current_org_id()
702: