APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_CA_INST_ALL

Line 1273: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

1269: CURSOR c_term1_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
1270: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
1271: cp_lev_dt DATE ) IS
1272: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
1273: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
1274: WHERE tr.term_cal_type = ca.cal_type AND
1275: tr.term_sequence_number = ca.sequence_number AND
1276: tr.person_id = cp_person_id AND
1277: tr.program_cd = cp_course_cd AND

Line 1289: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

1285: cp_lev_dt DATE ,
1286: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
1287: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
1288: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
1289: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
1290: WHERE tr.term_cal_type = ca.cal_type AND
1291: tr.term_sequence_number = ca.sequence_number AND
1292: tr.person_id = cp_person_id AND
1293: tr.program_cd = cp_course_cd AND

Line 1305: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

1301: cp_course_cd igs_en_spa_terms.program_cd%TYPE ,
1302: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
1303: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
1304: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
1305: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
1306: WHERE tr.term_cal_type = ca.cal_type AND
1307: tr.term_sequence_number = ca.sequence_number AND
1308: tr.person_id = cp_person_id AND
1309: tr.program_cd = cp_course_cd AND