DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on CST_PROJ_EXP_TYPES_VAL_V

Line 3530: FROM CST_PROJ_EXP_TYPES_VAL_V CET

3526: WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
3527: AND MTTY.TYPE_CLASS = 1 )
3528: AND NOT EXISTS (
3529: SELECT NULL
3530: FROM CST_PROJ_EXP_TYPES_VAL_V CET
3531: WHERE CET.EXPENDITURE_TYPE = MTI.EXPENDITURE_TYPE
3532: AND CET.COST_ELEMENT_ID = 1
3533: AND TRUNC(MTI.TRANSACTION_DATE) >= CET.SYS_LINK_START_DATE
3534: AND TRUNC(MTI.TRANSACTION_DATE) <= NVL(SYS_LINK_END_DATE,