DBA Data[Home] [Help]

APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_OR_INST_STAT

Line 175: IN (SELECT INSTITUTION_STATUS FROM IGS_OR_INST_STAT WHERE S_INSTITUTION_STATUS = 'ACTIVE' AND CLOSED_IND = 'N');

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.
179: CURSOR c_Assessment_Test_Type ( cp_ACT_Batch_Id IGS_AD_ACT_ASSESSMENTS.ACT_BATCH_ID%type,