APPS.IGR_VAL_EAP dependencies on IGS_CA_STAT

Line 122: FROM IGS_CA_STAT cs,

118: CURSOR c_ci_cs (
119: cp_acad_cal_type IGR_I_APPL.acad_cal_type%TYPE,
120: cp_acad_ci_sequence_number IGR_I_APPL.acad_ci_sequence_number%TYPE) IS
121: SELECT cs.s_cal_status
122: FROM IGS_CA_STAT cs,
123: IGS_CA_INST ci
124: WHERE ci.cal_type = cp_acad_cal_type AND
125: ci.sequence_number = cp_acad_ci_sequence_number AND
126: ci.cal_status = cs.cal_status;

Line 184: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

180: DECLARE
181: cst_admission CONSTANT VARCHAR2(10) := 'ADMISSION';
182: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
183: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
184: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
185: v_dummy VARCHAR2(1);
186: CURSOR c_cal_type (
187: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
188: SELECT cat.s_cal_cat

Line 196: IGS_CA_STAT cs

192: cp_cal_type IGS_CA_INST.cal_type%TYPE,
193: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
194: SELECT cs.s_cal_status
195: FROM IGS_CA_INST ci,
196: IGS_CA_STAT cs
197: WHERE ci.cal_status= cs.cal_status AND
198: ci.cal_type = cp_cal_type AND
199: ci.sequence_number = cp_sequence_number;
200: CURSOR c_cal_ins_rel (