114: AND CCT.COST_TYPE = CICDI.COST_TYPE
115: ),
116: DEPARTMENT_ID = (
117: SELECT BD.DEPARTMENT_ID
118: FROM BOM_DEPARTMENTS BD
119: WHERE BD.ORGANIZATION_ID = CICDI.ORGANIZATION_ID
120: AND BD.DEPARTMENT_CODE = CICDI.DEPARTMENT
121: ),
122: ACTIVITY_ID = (