APPS.IGS_AS_GEN_001 dependencies on IGS_CA_STAT

Line 700: igs_ca_stat cs

696: AND uc.unit_cat = p_exclude_unit_category;
697: CURSOR c_ci (cp_acad_cal_type igs_ca_inst.cal_type%TYPE, cp_acad_ci_seq_no igs_ca_inst.sequence_number%TYPE) IS
698: SELECT 'x'
699: FROM igs_ca_inst ci,
700: igs_ca_stat cs
701: WHERE ci.cal_type = cp_acad_cal_type
702: AND ci.sequence_number = cp_acad_ci_seq_no
703: AND ci.cal_status = cs.cal_status
704: AND cs.s_cal_status = cst_active;