APPS.IGS_EN_SUA_API dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 630: FROM igs_ca_load_to_teach_v

626: WHERE person_id = cp_person_id
627: AND unit_attempt_status =cst_waitlisted
628: AND (cal_type, ci_sequence_number) IN
629: (SELECT teach_cal_type, teach_ci_sequence_number
630: FROM igs_ca_load_to_teach_v
631: WHERE load_cal_type = cp_load_cal_type
632: AND load_ci_sequence_number = cp_load_seq_num);
633:
634: CURSOR cur_mus_allwd(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,