DBA Data[Home] [Help]

APPS.INV_PROCESS_TEMP dependencies on CST_COST_GROUPS

Line 947: FROM CST_COST_GROUPS CCG

943: AND TRANSACTION_SOURCE_TYPE_ID = 13
944: AND COST_GROUP_ID IS NOT NULL
945: AND NOT EXISTS (
946: SELECT NULL
947: FROM CST_COST_GROUPS CCG
948: WHERE CCG.COST_GROUP_ID = MMTT.COST_GROUP_ID
949: AND NVL(CCG.ORGANIZATION_ID, MMTT.ORGANIZATION_ID) = MMTT.ORGANIZATION_ID
950: AND TRUNC(NVL(CCG.DISABLE_DATE,SYSDATE+1)) >= TRUNC(SYSDATE) ) ;
951: if(SQL%FOUND) then return 0; else return 1; end if;