APPS.IGS_HE_IDENTIFY_TARGET_POP dependencies on IGS_CA_INST_ALL

Line 893: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

889: CURSOR c_term_lev( cp_person_id igs_en_spa_terms.person_id%TYPE,
890: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
891: cp_lev_dt DATE ) IS
892: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
893: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
894: WHERE tr.term_cal_type = ca.cal_type AND
895: tr.term_sequence_number = ca.sequence_number AND
896: tr.person_id = cp_person_id AND
897: tr.program_cd = cp_course_cd AND

Line 908: FROM igs_en_spa_terms tr , igs_ca_inst_all ca

904: cp_course_cd igs_en_spa_terms.program_cd%TYPE,
905: cp_sub_start_dt igs_he_submsn_header.enrolment_start_date%TYPE ,
906: cp_sub_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
907: SELECT tr.program_version , tr.acad_cal_type, tr.location_cd, tr.attendance_mode, tr.attendance_type
908: FROM igs_en_spa_terms tr , igs_ca_inst_all ca
909: WHERE tr.term_cal_type = ca.cal_type AND
910: tr.term_sequence_number = ca.sequence_number AND
911: tr.person_id = cp_person_id AND
912: tr.program_cd = cp_course_cd AND