APPS.IGS_AS_VAL_ESE dependencies on IGS_CA_DA_INST_V

Line 89: cp_exam_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

85: -- situations
86: DECLARE
87: v_alias_val IGS_AS_EXAM_SESSION_V.alias_val%TYPE;
88: CURSOR c_daiv(
89: cp_exam_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
90: cp_exam_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
91: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
92: cp_dai_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE) IS
93: SELECT daiv.alias_val

Line 90: cp_exam_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,

86: DECLARE
87: v_alias_val IGS_AS_EXAM_SESSION_V.alias_val%TYPE;
88: CURSOR c_daiv(
89: cp_exam_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
90: cp_exam_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
91: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
92: cp_dai_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE) IS
93: SELECT daiv.alias_val
94: FROM IGS_CA_DA_INST_V daiv

Line 91: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,

87: v_alias_val IGS_AS_EXAM_SESSION_V.alias_val%TYPE;
88: CURSOR c_daiv(
89: cp_exam_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
90: cp_exam_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
91: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
92: cp_dai_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE) IS
93: SELECT daiv.alias_val
94: FROM IGS_CA_DA_INST_V daiv
95: WHERE daiv.cal_type = cp_exam_cal_type AND

Line 92: cp_dai_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE) IS

88: CURSOR c_daiv(
89: cp_exam_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
90: cp_exam_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
91: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
92: cp_dai_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE) IS
93: SELECT daiv.alias_val
94: FROM IGS_CA_DA_INST_V daiv
95: WHERE daiv.cal_type = cp_exam_cal_type AND
96: daiv.ci_sequence_number = cp_exam_ci_sequence_number AND

Line 94: FROM IGS_CA_DA_INST_V daiv

90: cp_exam_ci_sequence_number IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
91: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE,
92: cp_dai_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE) IS
93: SELECT daiv.alias_val
94: FROM IGS_CA_DA_INST_V daiv
95: WHERE daiv.cal_type = cp_exam_cal_type AND
96: daiv.ci_sequence_number = cp_exam_ci_sequence_number AND
97: daiv.dt_alias = cp_dt_alias AND
98: daiv.sequence_number = cp_dai_sequence_number;