APPS.IGS_HE_EXTRACT2_PKG dependencies on IGS_CA_INST_ALL

Line 9795: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

9791: CURSOR c_term1_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
9792: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
9793: cp_lev_dt DATE ) IS
9794: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type, tr.fee_cat
9795: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
9796: WHERE tr.term_cal_type = ca.cal_type AND
9797: tr.term_sequence_number = ca.sequence_number AND
9798: tr.person_id = cp_person_id AND
9799: tr.program_cd = cp_course_cd AND

Line 9811: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

9807: cp_lev_dt DATE,
9808: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
9809: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE ) IS
9810: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type , tr.fee_cat
9811: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
9812: WHERE tr.term_cal_type = ca.cal_type AND
9813: tr.term_sequence_number = ca.sequence_number AND
9814: tr.person_id = cp_person_id AND
9815: tr.program_cd = cp_course_cd AND

Line 9827: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

9823: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
9824: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
9825: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE ) IS
9826: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type, tr.fee_cat
9827: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
9828: WHERE tr.term_cal_type = ca.cal_type AND
9829: tr.term_sequence_number = ca.sequence_number AND
9830: tr.person_id = cp_person_id AND
9831: tr.program_cd = cp_course_cd AND