DBA Data[Home] [Help]

APPS.IGS_EN_SU_ATTEMPT_PKG dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 2573: (SELECT load_cal_type,load_ci_sequence_number FROM igs_ca_load_to_teach_v ltCal

2569: FROM igs_en_spa_terms spat
2570: WHERE spat.person_id = p_person_id
2571: AND program_cd=p_course_cd AND plan_sht_status IN ('PLAN', 'NONE')
2572: AND EXISTS
2573: (SELECT load_cal_type,load_ci_sequence_number FROM igs_ca_load_to_teach_v ltCal
2574: WHERE ltCal.teach_cal_type = p_cal_type AND ltCal.teach_ci_sequence_number = p_ci_sequence_number
2575: AND ltCal.load_cal_type = spat.term_cal_type AND ltCal.load_ci_sequence_number = spat.term_sequence_number) ;
2576:
2577: v_dummy c_other_key_recs%ROWTYPE;