APPS.PA_REVERSE_COSTED_LAB dependencies on PA_EXPEND_ITEM_ADJ_ACTIVITIES

Line 287: (SELECT EXPENDITURE_ITEM_ID FROM PA_EXPEND_ITEM_ADJ_ACTIVITIES ADJ

283: SUBSTR(EI5.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI5.ORIG_TRANSACTION_REFERENCE,':') - 1)
284: AND NVL(EI4.NET_ZERO_ADJUSTMENT_FLAG,'N') = 'N'
285: AND EI4.INTERFACE_RUN_ID IS NULL
286: AND NOT EXISTS
287: (SELECT EXPENDITURE_ITEM_ID FROM PA_EXPEND_ITEM_ADJ_ACTIVITIES ADJ
288: WHERE ADJ.EXPENDITURE_ITEM_ID = EI4.EXPENDITURE_ITEM_ID
289: AND ADJ.MODULE_CODE = 'PAXREVTXN'
290: AND EXCEPTION_ACTIVITY_CODE = 'REINITIATE EI TO DIST' )
291: ) ; --Added for Bug 12779047

Line 801: (SELECT EXPENDITURE_ITEM_ID FROM PA_EXPEND_ITEM_ADJ_ACTIVITIES ADJ

797: SUBSTR(EI5.ORIG_TRANSACTION_REFERENCE,1,INSTR(EI5.ORIG_TRANSACTION_REFERENCE,':') - 1)
798: AND NVL(EI4.NET_ZERO_ADJUSTMENT_FLAG,'N') = 'N'
799: AND EI4.INTERFACE_RUN_ID IS NULL
800: AND NOT EXISTS
801: (SELECT EXPENDITURE_ITEM_ID FROM PA_EXPEND_ITEM_ADJ_ACTIVITIES ADJ
802: WHERE ADJ.EXPENDITURE_ITEM_ID = EI4.EXPENDITURE_ITEM_ID
803: AND ADJ.MODULE_CODE = 'PAXREVTXN'
804: AND EXCEPTION_ACTIVITY_CODE = 'REINITIATE EI TO DIST' ) );
805: