APPS.IGS_OR_INST_IMP_001 dependencies on IGS_AD_CODE_CLASSES

Line 108: cp_class igs_ad_code_classes.class%TYPE,

104:
105: c_institution_stat_rec c_institution_stat%rowtype;
106:
107: cursor c_sec_school_loc_id(cp_sec_school_location_id IGS_OR_INST_INT.sec_school_location_id%TYPE,
108: cp_class igs_ad_code_classes.class%TYPE,
109: cp_closed_ind igs_ad_code_classes.closed_ind%TYPE) is
110: select 'X' from
111: igs_ad_code_classes acc --ssawhney, view to table
112: where class = cp_class and

Line 109: cp_closed_ind igs_ad_code_classes.closed_ind%TYPE) is

105: c_institution_stat_rec c_institution_stat%rowtype;
106:
107: cursor c_sec_school_loc_id(cp_sec_school_location_id IGS_OR_INST_INT.sec_school_location_id%TYPE,
108: cp_class igs_ad_code_classes.class%TYPE,
109: cp_closed_ind igs_ad_code_classes.closed_ind%TYPE) is
110: select 'X' from
111: igs_ad_code_classes acc --ssawhney, view to table
112: where class = cp_class and
113: NVL(closed_ind,cp_closed_ind)=cp_closed_ind and

Line 111: igs_ad_code_classes acc --ssawhney, view to table

107: cursor c_sec_school_loc_id(cp_sec_school_location_id IGS_OR_INST_INT.sec_school_location_id%TYPE,
108: cp_class igs_ad_code_classes.class%TYPE,
109: cp_closed_ind igs_ad_code_classes.closed_ind%TYPE) is
110: select 'X' from
111: igs_ad_code_classes acc --ssawhney, view to table
112: where class = cp_class and
113: NVL(closed_ind,cp_closed_ind)=cp_closed_ind and
114: code_id= cp_sec_school_location_id;
115: