[Home] [Help]
4065:
4066: CURSOR c_un_inst IS
4067: SELECT ihpinst.oi_govt_institution_cd govt_institution_cd
4068: FROM igs_en_su_attempt a,
4069: igs_ps_tch_resp b,
4070: igs_pe_hz_parties ihpou,
4071: igs_pe_hz_parties ihpinst,
4072: igs_he_st_unt_vs_all hunt
4073: WHERE a.course_cd = p_course_cd
4177: -- updated cursor for HZ_PARTIES.PARTY_NUMBER issue - bug #4401841
4178: CURSOR c_other_inst_cp IS
4179: SELECT SUM( NVL(override_enrolled_cp,NVL(cps.enrolled_credit_points,e.enrolled_credit_points)) * b.percentage / 100 ) other_inst_cp
4180: FROM igs_en_su_attempt a,
4181: igs_ps_tch_resp b,
4182: igs_pe_hz_parties ihpou,
4183: igs_pe_hz_parties ihpinst,
4184: igs_ps_unit_ver e,
4185: igs_ps_usec_cps cps,
4648: CURSOR unit_cc_dtls_cur IS
4649: SELECT 'X'
4650: FROM igs_he_unt_ou_cc a,
4651: igs_en_su_attempt_all b,
4652: igs_ps_tch_resp c,
4653: igs_he_st_unt_vs_all hunt
4654: WHERE b.course_cd = p_course_cd
4655: AND b.person_id = p_person_id
4656: AND a.unit_cd = b.unit_cd
4668: CURSOR unit_org_cc_dtls_cur IS
4669: SELECT 'X'
4670: FROM
4671: igs_he_ou_cc org,
4672: igs_ps_tch_resp ps,
4673: igs_en_su_attempt_all su
4674: WHERE
4675: org.org_unit_cd = ps.org_unit_cd
4676: AND ps.unit_cd = su.unit_cd
4683: -- Cost Centers at Module Level
4684: CURSOR module_cc_dtls_cur IS
4685: SELECT 'X'
4686: FROM igs_he_unt_ou_cc ucc,
4687: igs_ps_tch_resp ptr
4688: WHERE ucc.unit_cd = p_unit_cd
4689: AND ucc.version_number = p_uv_version_number
4690: AND ucc.unit_cd = ptr.unit_cd
4691: AND ucc.version_number = ptr.version_number
4694: -- Cost Centers at Module / Org Level
4695: CURSOR module_org_cc_dtls_cur IS
4696: SELECT 'X'
4697: FROM igs_he_ou_cc org,
4698: igs_ps_tch_resp ptr
4699: WHERE ptr.unit_cd = p_unit_cd
4700: AND ptr.version_number = p_uv_version_number
4701: AND ptr.org_unit_cd = org.org_unit_cd;
4702:
4877: a.subject,
4878: SUM(proportion*percentage/100) proportion
4879: FROM igs_he_unt_ou_cc a,
4880: igs_en_su_attempt_all b,
4881: igs_ps_tch_resp c,
4882: igs_he_st_unt_vs_all hunt
4883: WHERE b.course_cd = p_course_cd
4884: AND b.person_id = p_person_id
4885: AND a.unit_cd = b.unit_cd
4908: SELECT org.cost_centre,
4909: org.subject,
4910: SUM(ps.percentage * org.proportion / 100) proportion
4911: FROM igs_he_ou_cc org,
4912: igs_ps_tch_resp ps,
4913: igs_en_su_attempt_all su
4914: WHERE org.org_unit_cd = ps.org_unit_cd
4915: AND ps.unit_cd = su.unit_cd
4916: AND ps.version_number = su.version_number
4949: SELECT cost_centre,
4950: subject,
4951: SUM(proportion*percentage/100) proportion
4952: FROM igs_he_unt_ou_cc ucc,
4953: igs_ps_tch_resp ptr
4954: WHERE ucc.unit_cd = p_unit_cd
4955: AND ucc.version_number = p_uv_version_number
4956: AND ucc.unit_cd = ptr.unit_cd
4957: AND ucc.version_number = ptr.version_number
4971: SELECT cost_centre,
4972: subject,
4973: SUM(proportion*percentage/100) proportion
4974: FROM igs_he_ou_cc org,
4975: igs_ps_tch_resp ptr
4976: WHERE ptr.unit_cd = p_unit_cd
4977: AND ptr.version_number = p_uv_version_number
4978: AND ptr.org_unit_cd = org.org_unit_cd
4979: GROUP BY cost_centre, subject
6594: -- anwest 09-Jun-05
6595: -- updated cursor for HZ_PARTIES.PARTY_NUMBER issue - bug #4401841
6596: CURSOR c_perc IS
6597: SELECT SUM(percentage)
6598: FROM igs_ps_tch_resp a,
6599: igs_pe_hz_parties ihpou,
6600: igs_pe_hz_parties ihpinst
6601: WHERE a.unit_cd = p_unit_cd
6602: AND a.version_number = p_version_number
6648: -- updated cursor for HZ_PARTIES.PARTY_NUMBER issue - bug #4401841
6649: CURSOR c_oinst IS
6650: SELECT SUM(percentage) percentage,
6651: ihpinst.oi_govt_institution_cd govt_institution_cd
6652: FROM igs_ps_tch_resp a,
6653: igs_pe_hz_parties ihpou,
6654: igs_pe_hz_parties ihpinst
6655: WHERE a.unit_cd = p_unit_cd
6656: AND a.version_number = p_version_number