APPS.IGS_AS_GEN_001 dependencies on IGS_AD_ADM_UNIT_STAT

Line 665: FROM igs_ad_adm_unit_stat aus

661: cst_enrolled CONSTANT VARCHAR2 (15) := 'ENROLLED';
662: cst_active CONSTANT VARCHAR2 (15) := 'ACTIVE';
663: CURSOR c_aus IS
664: SELECT 'x'
665: FROM igs_ad_adm_unit_stat aus
666: WHERE aus.administrative_unit_status = p_administrative_unit_status
667: AND aus.show_on_offic_ntfctn_ind = 'N';
668: CURSOR c_gsg (
669: cp_grading_schema_cd igs_as_grd_sch_grade.grading_schema_cd%TYPE,