DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on PA_ORGANIZATIONS_EXPEND_V

Line 6957: FROM PA_ORGANIZATIONS_EXPEND_V POE

6953: WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
6954: AND MTTY.TYPE_CLASS = 1 )
6955: AND NOT EXISTS (
6956: SELECT NULL
6957: FROM PA_ORGANIZATIONS_EXPEND_V POE
6958: WHERE POE.ORGANIZATION_ID = MTI.PA_EXPENDITURE_ORG_ID
6959: AND TRUNC(SYSDATE) BETWEEN POE.DATE_FROM
6960: AND NVL(POE.DATE_TO, TRUNC(SYSDATE)));
6961: