DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_GRP dependencies on PA_ORGANIZATIONS_EXPEND_V

Line 6486: FROM PA_ORGANIZATIONS_EXPEND_V POE

6482: WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID
6483: AND MTTY.TYPE_CLASS = 1 )
6484: AND NOT EXISTS (
6485: SELECT NULL
6486: FROM PA_ORGANIZATIONS_EXPEND_V POE
6487: WHERE POE.ORGANIZATION_ID = MTI.PA_EXPENDITURE_ORG_ID
6488: AND TRUNC(SYSDATE) BETWEEN POE.DATE_FROM
6489: AND NVL(POE.DATE_TO, TRUNC(SYSDATE)));
6490: