DBA Data[Home] [Help]

APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on AHL_POSITION_ALTERNATES_V

Line 875: AHL_POSITION_ALTERNATES_V PA

871: IS
872: SELECT 'X'
873: FROM MTL_SYSTEM_ITEMS_KFV MTL,
874: FND_LOOKUP_VALUES_VL IT,
875: AHL_POSITION_ALTERNATES_V PA
876: WHERE MTL.SERVICE_ITEM_FLAG = 'N'
877: AND IT.LOOKUP_CODE (+) = MTL.ITEM_TYPE
878: AND IT.LOOKUP_TYPE (+) = 'ITEM_TYPE'
879: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(IT.START_DATE_ACTIVE,SYSDATE))