APPS.IGS_EN_ELGB_OVR_UOO_PKG dependencies on IGS_CA_TEACH_TO_LOAD_V

Line 147: FROM igs_ca_teach_to_load_v

143: l_cal_cat_rec cur_cal_cat%ROWTYPE;
144: -- Cursor to fetch most recent active Term Calendar corresponding to the given teaching calendar
145: CURSOR cur_teach_term(cp_cal_type VARCHAR2,cp_sequence_number NUMBER) IS
146: SELECT load_cal_type,load_ci_sequence_number
147: FROM igs_ca_teach_to_load_v
148: WHERE teach_cal_type = cp_cal_type AND
149: teach_ci_sequence_number = cp_sequence_number AND
150: load_end_dt >= TRUNC(SYSDATE)
151: ORDER BY load_start_dt ;

Line 855: FROM igs_ca_teach_to_load_v

851: AND ((plan.term_cal_type = :4 AND
852: plan.term_ci_sequence_number = :5 ) OR
853: ((plan.term_cal_type,plan.term_ci_sequence_number) IN
854: (SELECT load_cal_type,load_ci_sequence_number
855: FROM igs_ca_teach_to_load_v
856: WHERE teach_cal_type = :6 AND teach_ci_sequence_number = :7 )))
857: AND EXISTS(SELECT ''x'' FROM igs_en_spa_terms spa
858: where spa.person_id=plan.person_id
859: and spa.program_cd=plan.course_cd

Line 879: FROM igs_ca_teach_to_load_v

875: AND ((plan.term_cal_type = :2 AND
876: plan.term_ci_sequence_number = :3 ) OR
877: ((plan.term_cal_type,plan.term_ci_sequence_number) IN
878: (SELECT load_cal_type,load_ci_sequence_number
879: FROM igs_ca_teach_to_load_v
880: WHERE teach_cal_type = :4 AND teach_ci_sequence_number = :5 )))
881: AND EXISTS(SELECT ''x'' FROM igs_en_spa_terms spa
882: WHERE spa.person_id=plan.person_id
883: and spa.program_cd=plan.course_cd