[Home] [Help]
170: AND actas.ACT_Identifier like nvl(cp_ACT_Id,'%')
171: AND actas.Interface_Transfer_Date IS NULL
172: AND actas.High_School_Code IS NOT NULL
173: MINUS
174: SELECT INSTITUTION_CD FROM IGS_OR_INSTITUTION WHERE INSTITUTION_STATUS
175: IN (SELECT INSTITUTION_STATUS FROM IGS_OR_INST_STAT WHERE S_INSTITUTION_STATUS = 'ACTIVE' AND CLOSED_IND = 'N');
176:
177:
178: -- Cursor to Check the Assessments Test Type Setup.