APPS.IGS_EN_IVR_PUB dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 192: FROM igs_ca_load_to_teach_v

188: FROM igs_en_su_attempt sua
189: WHERE sua.person_id = l_person_id
190: AND sua.course_cd = l_primary_code
191: AND (sua.cal_type, sua.ci_sequence_number) IN (SELECT teach_cal_type,teach_ci_sequence_number
192: FROM igs_ca_load_to_teach_v
193: WHERE load_cal_type = l_cal_type
194: AND load_ci_sequence_number = l_ci_sequence_number)
195: AND sua.unit_attempt_status IN ('INVALID','UNCONFIRM') ;
196:

Line 984: FROM igs_ca_load_to_teach_v

980: sua.person_id = cp_person_id AND
981: sua.course_cd = cp_program_cd AND
982: (sua.cal_type ,sua.ci_sequence_number) IN
983: (SELECT teach_cal_type,teach_ci_sequence_number
984: FROM igs_ca_load_to_teach_v
985: WHERE load_cal_type = cp_load_cal_type AND
986: load_ci_sequence_number = cp_load_ci_sequence_number) AND
987: sua.unit_attempt_status NOT IN (cp_unit_status_not_shown) AND
988: sua1.person_id = sua.person_id AND

Line 1171: FROM igs_ca_load_to_teach_v

1167: sua.person_id = cp_person_id AND
1168: sua.course_cd = cp_program_cd AND
1169: (sua.cal_type ,sua.ci_sequence_number) IN
1170: (SELECT teach_cal_type,teach_ci_sequence_number
1171: FROM igs_ca_load_to_teach_v
1172: WHERE load_cal_type = cp_load_cal_type AND
1173: load_ci_sequence_number = cp_load_ci_sequence_number) AND
1174: sua.unit_attempt_status IN ('INVALID','UNCONFIRM');
1175: BEGIN