APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_HE_UNT_OU_CC

Line 4650: FROM igs_he_unt_ou_cc a,

4646:
4647: -- Cost Centers at Unit Level
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

Line 4686: FROM igs_he_unt_ou_cc ucc,

4682:
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

Line 4879: FROM igs_he_unt_ou_cc a,

4875: OPEN c_cc FOR
4876: SELECT a.cost_centre,
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

Line 4947: -- jbaber modified to use igs_he_unt_ou_cc

4943: CLOSE module_cc_dtls_cur;
4944:
4945: -- smaddali modified this cursor to include unit credit points and taking proportion of unit credit points
4946: -- instead of directly the proportion field of cost centre
4947: -- jbaber modified to use igs_he_unt_ou_cc
4948: OPEN c_cc FOR
4949: SELECT cost_centre,
4950: subject,
4951: SUM(proportion*percentage/100) proportion

Line 4952: FROM igs_he_unt_ou_cc ucc,

4948: OPEN c_cc FOR
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