APPS.IGF_SP_AWARD dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 531: FROM igs_ca_load_to_teach_v

527: WHERE sua.person_id = psatt.person_id
528: AND sua.course_cd = psatt.course_cd
529: AND sua.unit_attempt_status IN ('ENROLLED','COMPLETED')
530: AND (cal_type, ci_sequence_number) IN ( SELECT teach_cal_type, teach_ci_sequence_number
531: FROM igs_ca_load_to_teach_v
532: WHERE load_cal_type = cp_v_load_cal_type
533: AND load_ci_sequence_number = cp_n_load_seq_num)
534: );
535: