DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on CST_COST_GROUPS

Line 815: FROM CST_COST_GROUPS CCG

811: l_count := 0;
812:
813: BEGIN
814: SELECT COUNT(1) INTO l_count
815: FROM CST_COST_GROUPS CCG
816: WHERE CCG.COST_GROUP_ID = p_mtl_trx_tbl(i).cost_group_id
817: AND NVL(CCG.ORGANIZATION_ID, p_mtl_trx_tbl(i).organization_id) = p_mtl_trx_tbl(i).organization_id
818: AND TRUNC(NVL(CCG.DISABLE_DATE,SYSDATE+1)) >= TRUNC(SYSDATE);
819: EXCEPTION

Line 861: FROM CST_COST_GROUPS CCG

857: l_count := 0;
858:
859: BEGIN
860: SELECT COUNT(1) INTO l_count
861: FROM CST_COST_GROUPS CCG
862: WHERE CCG.COST_GROUP_ID = p_mtl_trx_tbl(i).transfer_cost_group_id
863: AND NVL(CCG.ORGANIZATION_ID, p_mtl_trx_tbl(i).transfer_organization_id) = p_mtl_trx_tbl(i).transfer_organization_id
864: AND TRUNC(NVL(CCG.DISABLE_DATE,SYSDATE+1)) >= TRUNC(SYSDATE);
865: EXCEPTION