DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on CST_PROJ_EXP_TYPES_VAL_V

Line 3717: FROM CST_PROJ_EXP_TYPES_VAL_V CET

3713: WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
3714: AND MTTY.TYPE_CLASS = 1 )
3715: AND NOT EXISTS (
3716: SELECT NULL
3717: FROM CST_PROJ_EXP_TYPES_VAL_V CET
3718: WHERE CET.EXPENDITURE_TYPE = MTI.EXPENDITURE_TYPE
3719: AND CET.COST_ELEMENT_ID = 1
3720: AND TRUNC(MTI.TRANSACTION_DATE) >= CET.SYS_LINK_START_DATE
3721: AND TRUNC(MTI.TRANSACTION_DATE) <= NVL(SYS_LINK_END_DATE,