SELECT DISTINCT XFACE.BATCH_NAME , XFACE.TRANSACTION_SOURCE , XFACE.ORG_ID FROM PA_TRANSACTION_XFACE_CONTROL XFACE WHERE STATUS = 'PENDING' UNION SELECT DISTINCT USER_BATCH_NAME , 'ORACLE SELF SERVICE TIME' , EXP.ORG_ID FROM PA_EXPENDITURES EXP WHERE EXP.TRANSFER_STATUS_CODE IN ( 'R' , 'P') AND EXP.USER_BATCH_NAME IS NOT NULL AND EXP.EXPENDITURE_STATUS_CODE = 'APPROVED'