APPS.IGS_EN_VAL_PCE dependencies on IGS_CA_DA_INST_V

Line 192: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

188: WHERE person_id = p_person_id AND
189: course_cd = p_course_cd AND
190: unit_attempt_status = 'ENROLLED';
191: CURSOR c_check_census_dt (
192: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
193: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
194: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
195: SELECT 'x'
196: FROM IGS_CA_DA_INST_V

Line 193: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,

189: course_cd = p_course_cd AND
190: unit_attempt_status = 'ENROLLED';
191: CURSOR c_check_census_dt (
192: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
193: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
194: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
195: SELECT 'x'
196: FROM IGS_CA_DA_INST_V
197: WHERE cal_type = cp_cal_type AND

Line 194: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS

190: unit_attempt_status = 'ENROLLED';
191: CURSOR c_check_census_dt (
192: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
193: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
194: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
195: SELECT 'x'
196: FROM IGS_CA_DA_INST_V
197: WHERE cal_type = cp_cal_type AND
198: ci_sequence_number = cp_ci_sequence_number AND

Line 196: FROM IGS_CA_DA_INST_V

192: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
193: cp_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
194: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
195: SELECT 'x'
196: FROM IGS_CA_DA_INST_V
197: WHERE cal_type = cp_cal_type AND
198: ci_sequence_number = cp_ci_sequence_number AND
199: dt_alias = cp_dt_alias AND
200: NVL(alias_val,IGS_GE_DATE.IGSDATE('1900/01/01'))