[Home] [Help]
1132: spat.location_cd,
1133: spat.attendance_mode,
1134: spat.attendance_type,
1135: ps.course_type
1136: FROM igs_en_spa_terms spat,
1137: igs_en_stdnt_ps_att_all sca,
1138: igs_ps_ver_all ps,
1139: igs_lookups_view lkps
1140: WHERE spat.person_id = p_person_id
1179: IF (p_s_fee_trigger_cat = 'INSTITUTN' OR g_c_fee_calc_mthd = g_v_primary_career) THEN -- For Institutional Level
1180: OPEN c_att_md_ty FOR SELECT a.attendance_type,
1181: b.govt_attendance_mode,
1182: a.attendance_mode
1183: FROM igs_en_spa_terms a,
1184: igs_en_atd_mode_all b
1185: WHERE a.person_id = p_person_id
1186: AND a.term_cal_type = g_v_load_cal_type
1187: AND a.term_sequence_number = g_n_load_seq_num
1190: ELSE -- For Other than Institutional Level
1191: OPEN c_att_md_ty FOR SELECT a.attendance_type,
1192: b.govt_attendance_mode,
1193: a.attendance_mode
1194: FROM igs_en_spa_terms a,
1195: igs_en_atd_mode_all b
1196: WHERE a.person_id = p_person_id
1197: AND a.program_cd = p_course_cd
1198: AND a.term_cal_type = g_v_load_cal_type
1353: -- Derive AM from Key Program of the person for the given term.
1354:
1355: OPEN c_scafv FOR SELECT program_cd course_cd,
1356: NULL
1357: FROM igs_en_spa_terms
1358: WHERE person_id = p_person_id
1359: AND term_cal_type = g_v_load_cal_type
1360: AND term_sequence_number = g_n_load_seq_num;
1361:
2021: IF (p_s_fee_trigger_cat = 'INSTITUTN' OR g_c_fee_calc_mthd = g_v_primary_career) THEN -- For Institutional Level
2022: OPEN c_att_md_ty FOR SELECT a.attendance_type,
2023: b.govt_attendance_mode,
2024: a.attendance_mode
2025: FROM igs_en_spa_terms a,
2026: igs_en_atd_mode_all b
2027: WHERE a.person_id = p_person_id
2028: AND a.term_cal_type = g_v_load_cal_type
2029: AND a.term_sequence_number = g_n_load_seq_num
2032: ELSE -- For Other than Institutional Level
2033: OPEN c_att_md_ty FOR SELECT a.attendance_type,
2034: b.govt_attendance_mode,
2035: a.attendance_mode
2036: FROM igs_en_spa_terms a,
2037: igs_en_atd_mode_all b
2038: WHERE a.person_id = p_person_id
2039: AND a.program_cd = p_course_cd
2040: AND a.term_cal_type = g_v_load_cal_type
2186: -- Derive AM from Key Program of the person for the given term.
2187:
2188: OPEN c_scafv FOR SELECT program_cd course_cd,
2189: NULL
2190: FROM igs_en_spa_terms
2191: WHERE person_id = p_person_id
2192: AND term_cal_type = g_v_load_cal_type
2193: AND term_sequence_number = g_n_load_seq_num;
2194:
4652: -- Cursor to derive Key Program for a given student and for a given term.
4653: CURSOR c_key_program ( cp_n_person_id PLS_INTEGER,
4654: cp_v_load_cal_type igs_fi_f_cat_ca_inst.fee_cal_type%TYPE,
4655: cp_n_load_ci_seq_num igs_fi_f_cat_ca_inst.fee_ci_sequence_number%TYPE,
4656: cp_v_key_prog_flag igs_en_spa_terms.key_program_flag%TYPE ) IS
4657: SELECT program_cd, program_version
4658: FROM igs_en_spa_terms
4659: WHERE person_id = cp_n_person_id
4660: AND term_cal_type = cp_v_load_cal_type
4654: cp_v_load_cal_type igs_fi_f_cat_ca_inst.fee_cal_type%TYPE,
4655: cp_n_load_ci_seq_num igs_fi_f_cat_ca_inst.fee_ci_sequence_number%TYPE,
4656: cp_v_key_prog_flag igs_en_spa_terms.key_program_flag%TYPE ) IS
4657: SELECT program_cd, program_version
4658: FROM igs_en_spa_terms
4659: WHERE person_id = cp_n_person_id
4660: AND term_cal_type = cp_v_load_cal_type
4661: AND term_sequence_number = cp_n_load_ci_seq_num
4662: AND key_program_flag = cp_v_key_prog_flag;
4667: cp_n_load_ci_seq_num NUMBER,
4668: cp_v_program_cd VARCHAR2,
4669: cp_v_fee_cat VARCHAR2,
4670: cp_v_course_type VARCHAR2,
4671: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
4672: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
4673: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE) IS
4674: SELECT esptv.person_id,
4675: esptv.program_cd,
4684: sca.commencement_dt,
4685: sca.discontinued_dt,
4686: psv.short_title,
4687: esptv.key_program_flag
4688: FROM igs_en_spa_terms esptv,
4689: igs_ps_ver_all psv,
4690: igs_en_stdnt_ps_att_all sca,
4691: igs_lookups_view scas
4692: WHERE esptv.program_cd = psv.course_cd
4720:
4721: CURSOR cur_spa (cp_n_person_id hz_parties.party_id%TYPE,
4722: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
4723: cp_n_load_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
4724: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
4725: cp_v_course_type igs_ps_ver_all.course_type%TYPE,
4726: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
4727: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE,
4728: cp_v_fee_cat igs_en_spa_terms.fee_cat%TYPE) IS
4724: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
4725: cp_v_course_type igs_ps_ver_all.course_type%TYPE,
4726: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
4727: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE,
4728: cp_v_fee_cat igs_en_spa_terms.fee_cat%TYPE) IS
4729: SELECT esptv.person_id,
4730: esptv.program_cd,
4731: esptv.program_version,
4732: psv.course_type,
4739: sca.commencement_dt,
4740: sca.discontinued_dt,
4741: psv.short_title,
4742: esptv.key_program_flag
4743: FROM igs_en_spa_terms esptv,
4744: igs_ps_ver_all psv,
4745: igs_en_stdnt_ps_att_all sca,
4746: igs_lookups_view scas
4747: WHERE esptv.program_cd = psv.course_cd
6846: sua.org_unit_cd,
6847: uoo.owner_org_unit_cd
6848: FROM igs_en_su_attempt_all sua,
6849: igs_lookups_view suas,
6850: igs_en_spa_terms terms,
6851: igs_ps_unit_ofr_opt_all uoo
6852: WHERE sua.person_id = p_person_id AND
6853: sua.person_id = terms.person_id AND
6854: sua.course_cd = terms.program_cd AND
6903: spat.location_cd,
6904: spat.attendance_mode,
6905: spat.attendance_type,
6906: ps.course_type
6907: FROM igs_en_spa_terms spat,
6908: igs_en_stdnt_ps_att_all sca,
6909: igs_ps_ver_all ps,
6910: igs_lookups_view lkps
6911: WHERE spat.person_id = p_person_id
7965: spa.cal_type,
7966: spt.location_cd,
7967: spt.attendance_mode,
7968: spt.attendance_type
7969: FROM igs_en_spa_terms spt,
7970: igs_en_stdnt_ps_att_all spa,
7971: igs_ps_ver_all ps,
7972: igs_lookups_view lkps
7973: WHERE spt.person_id = spa.person_id
9202: CURSOR c_get_term_recs(cp_n_person_id igs_fi_fee_as_items.person_id%TYPE,
9203: cp_v_fee_category igs_fi_fee_cat_all.fee_cat%TYPE,
9204: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9205: cp_v_career igs_ps_ver_all.course_type%TYPE,
9206: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
9207: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9208: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9209: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9210: cp_v_course_attempt_status4 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9222: spat.key_program_flag,
9223: sca.course_attempt_status,
9224: sca.commencement_dt,
9225: sca.discontinued_dt
9226: FROM igs_en_spa_terms spat,
9227: igs_en_stdnt_ps_att_all sca,
9228: igs_ps_ver_all psv
9229: WHERE spat.program_cd = psv.course_cd
9230: AND spat.program_version = psv.version_number