APPS.IGS_EN_GEN_013 dependencies on IGS_GE_S_GEN_CAL_CON

Line 134: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;

130: NO_S_GEN_CAL_CONF_REC_FOUND EXCEPTION;
131: v_message_name VARCHAR2(30);
132: v_administrative_unit_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
133: v_discontinuation_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
134: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
135: v_do_remove BOOLEAN:=FALSE;
136: -- Revision 23/07/97
137: e_vrn_cutoff_dt_alias_notfound EXCEPTION;
138: v_variation_cutoff_dt_alias IGS_EN_CAL_CONF.variation_cutoff_dt_alias%TYPE;

Line 165: FROM IGS_GE_S_GEN_CAL_CON

161: alias_val IS NOT NULL;
162:
163: CURSOR c_s_gen_cal_conf IS
164: SELECT census_dt_alias
165: FROM IGS_GE_S_GEN_CAL_CON
166: WHERE s_control_num = 1;
167:
168: CURSOR c_student_unit_attempt(
169: cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,