DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on CST_COST_GROUPS

Line 797: FROM CST_COST_GROUPS CCG

793: l_count := 0;
794:
795: BEGIN
796: SELECT COUNT(1) INTO l_count
797: FROM CST_COST_GROUPS CCG
798: WHERE CCG.COST_GROUP_ID = p_mtl_trx_tbl(i).cost_group_id
799: AND NVL(CCG.ORGANIZATION_ID, p_mtl_trx_tbl(i).organization_id) = p_mtl_trx_tbl(i).organization_id
800: AND TRUNC(NVL(CCG.DISABLE_DATE,SYSDATE+1)) >= TRUNC(SYSDATE);
801: EXCEPTION

Line 843: FROM CST_COST_GROUPS CCG

839: l_count := 0;
840:
841: BEGIN
842: SELECT COUNT(1) INTO l_count
843: FROM CST_COST_GROUPS CCG
844: WHERE CCG.COST_GROUP_ID = p_mtl_trx_tbl(i).transfer_cost_group_id
845: AND NVL(CCG.ORGANIZATION_ID, p_mtl_trx_tbl(i).transfer_organization_id) = p_mtl_trx_tbl(i).transfer_organization_id
846: AND TRUNC(NVL(CCG.DISABLE_DATE,SYSDATE+1)) >= TRUNC(SYSDATE);
847: EXCEPTION