APPS.IGS_EN_VAL_PCE dependencies on IGS_GE_S_GEN_CAL_CON

Line 176: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;

172: -- module only ever invoked with an enrolled IGS_PS_COURSE.
173: DECLARE
174: cst_warn CONSTANT VARCHAR2(1) := 'W';
175: cst_error CONSTANT VARCHAR2(1) := 'E';
176: v_census_dt_alias IGS_GE_S_GEN_CAL_CON.census_dt_alias%TYPE;
177: v_person_enrolled BOOLEAN DEFAULT FALSE;
178: v_validate_failed BOOLEAN DEFAULT FALSE;
179: v_check VARCHAR2(1);
180: CURSOR c_get_census_dt_alias IS

Line 182: FROM IGS_GE_S_GEN_CAL_CON

178: v_validate_failed BOOLEAN DEFAULT FALSE;
179: v_check VARCHAR2(1);
180: CURSOR c_get_census_dt_alias IS
181: SELECT census_dt_alias
182: FROM IGS_GE_S_GEN_CAL_CON
183: WHERE s_control_num = 1;
184: CURSOR c_student_unit_attempt IS
185: SELECT cal_type,
186: ci_sequence_number