APPS.IGF_SP_GEN_001 dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 358: FROM igs_ca_load_to_teach_v

354: AND unit_attempt_status IN ('ENROLLED', 'COMPLETED')
355: AND unit_cd = cp_unit_cd
356: AND version_number = cp_unit_version_number
357: AND (cal_type, ci_sequence_number) IN (SELECT teach_cal_type, teach_ci_sequence_number
358: FROM igs_ca_load_to_teach_v
359: WHERE load_cal_type = cp_ld_cal_type
360: AND load_ci_sequence_number = cp_ld_ci_sequence_number);
361: l_enroll c_enroll%ROWTYPE;
362: BEGIN