DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on GL_CODE_COMBINATIONS

Line 645: -- check for the distribution account from gl code combinations for

641: ******/
642: --13. Validate distribution account id
643: -- Assumption is that the distribution account id should have been
644: -- populated before passing the record for validation
645: -- check for the distribution account from gl code combinations for
646: -- that oraganization.
647:
648: IF (p_mtl_trx_tbl(i).distribution_account_id IS NULL) THEN
649: IF (l_debug = 1) THEN

Line 662: SELECT COUNT(1) INTO l_count FROM GL_CODE_COMBINATIONS GCC

658: p_mtl_trx_tbl(i).distribution_account_id, 9);
659:
660: l_count := 0;
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)