APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 4651: igs_en_su_attempt_all b,

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
4655: AND b.person_id = p_person_id

Line 4673: igs_en_su_attempt_all su

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
4677: AND ps.version_number = su.version_number

Line 4880: igs_en_su_attempt_all b,

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
4884: AND b.person_id = p_person_id

Line 4913: igs_en_su_attempt_all su

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
4917: AND su.person_id = p_person_id

Line 6132: FROM igs_en_su_attempt_all a,

6128: SELECT DISTINCT a.unit_cd,
6129: a.version_number,
6130: d.prop_of_teaching_in_welsh,
6131: NVL(cps.enrolled_credit_points,b.enrolled_credit_points) enrolled_credit_point
6132: FROM igs_en_su_attempt_all a,
6133: igs_ps_unit_ver_all b,
6134: igs_he_st_spa_all c,
6135: igs_he_st_unt_vs_all d,
6136: igs_ps_usec_cps cps

Line 6154: FROM igs_en_su_attempt_all a,

6150: SELECT DISTINCT a.unit_cd,
6151: a.version_number,
6152: d.prop_of_teaching_in_welsh,
6153: NVL(cps.enrolled_credit_points,b.enrolled_credit_points) enrolled_credit_point
6154: FROM igs_en_su_attempt_all a,
6155: igs_ps_unit_ver_all b,
6156: igs_he_st_spa_all c,
6157: igs_he_st_unt_vs_all d,
6158: igs_as_su_stmptout e,

Line 6189: igs_en_su_attempt_all sua,

6185: sua.no_assessment_ind,
6186: suo.outcome_dt,
6187: sua.uoo_id
6188: FROM igs_as_su_stmptout suo,
6189: igs_en_su_attempt_all sua,
6190: igs_he_st_spa_all spa
6191: WHERE suo.person_id = sua.person_id
6192: AND suo.course_cd = sua.course_cd
6193: AND suo.uoo_id = sua.uoo_id

Line 7535: igs_en_su_attempt_all su, igs_as_su_stmptout_all suo1,

7531: -- than or equal to the reporting period end date.
7532: CURSOR c_unit_count IS
7533: SELECT count(*)
7534: FROM
7535: igs_en_su_attempt_all su, igs_as_su_stmptout_all suo1,
7536: igs_he_st_spa spa1, igs_he_st_spa spa2, igs_as_grd_sch_grade gsg
7537: WHERE su.person_id = suo1.person_id
7538: AND su.course_cd = suo1.course_cd
7539: AND su.unit_cd = suo1.unit_cd