APPS.IGS_EN_SUA_LGCY_PUB dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 1111: FROM igs_ca_load_to_teach_v

1107: WHERE person_id = cp_person_id AND
1108: unit_attempt_status ='WAITLISTED' AND
1109: (cal_type,ci_sequence_number) IN
1110: (SELECT teach_cal_type,teach_ci_sequence_number
1111: FROM igs_ca_load_to_teach_v
1112: WHERE load_cal_type = cp_load_cal_type AND
1113: load_ci_sequence_number = cp_load_ci_sequence_number);
1114:
1115: --