APPS.IGS_EN_VAL_SCA dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 1522: FROM igs_ca_teach_to_load_v

1518:
1519: CURSOR c_get_teach_to_load_cal(cp_cal_type IGS_CA_INST.cal_type%TYPE,
1520: cp_seq_number IGS_CA_INST.sequence_number%TYPE) IS
1521: SELECT load_cal_type,load_ci_sequence_number
1522: FROM igs_ca_teach_to_load_v
1523: WHERE teach_cal_type = cp_cal_type
1524: AND teach_ci_sequence_number = cp_seq_number
1525: ORDER BY load_start_dt;
1526:

Line 2736: From igs_ca_teach_to_load_V tlv,

2732:
2733: CURSOR c_sua_term (cp_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,
2734: cp_course_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE) IS
2735: SELECT tlv.LOAD_END_DT
2736: From igs_ca_teach_to_load_V tlv,
2737: igs_en_su_attempt sua
2738: Where sua.person_id = cp_person_id
2739: AND sua.course_cd = cp_course_cd
2740: AND sua.unit_attempt_status NOT IN ('DROPPED','UNCONFIRM')