APPS.IGS_AD_VAL_AA dependencies on IGS_CA_STAT

Line 249: FROM IGS_CA_STAT cs,

245: CURSOR c_ci_cs (
246: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
247: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS
248: SELECT cs.s_cal_status
249: FROM IGS_CA_STAT cs,
250: IGS_CA_INST ci
251: WHERE ci.cal_type = cp_acad_cal_type AND
252: ci.sequence_number = cp_acad_ci_sequence_number AND
253: ci.cal_status = cs.cal_status;

Line 329: IGS_CA_STAT cs

325: cp_cal_type IGS_CA_INST.cal_type%TYPE,
326: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
327: SELECT cs.s_cal_status
328: FROM IGS_CA_INST ci,
329: IGS_CA_STAT cs
330: WHERE ci.cal_status = cs.cal_status AND
331: ci.cal_type = cp_cal_type AND
332: ci.sequence_number = cp_sequence_number;
333: CURSOR c_cal_ins_rel (