DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 665: FROM ORG_ORGANIZATION_DEFINITIONS OOD

661: BEGIN
662: SELECT COUNT(1) INTO l_count FROM GL_CODE_COMBINATIONS GCC
663: WHERE GCC.CODE_COMBINATION_ID = p_mtl_trx_tbl(i).distribution_account_id
664: AND GCC.CHART_OF_ACCOUNTS_ID = (SELECT CHART_OF_ACCOUNTS_ID
665: FROM ORG_ORGANIZATION_DEFINITIONS OOD
666: WHERE OOD.ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id)
667: AND GCC.ENABLED_FLAG = 'Y'
668: AND NVL(GCC.START_DATE_ACTIVE, SYSDATE - 1) <= SYSDATE
669: AND NVL(GCC.END_DATE_ACTIVE, SYSDATE + 1) > SYSDATE;