eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_EN_SU_ATTEMPT

Line 1640: igs_en_su_attempt sua,

1636: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE ) IS
1637: SELECT COUNT (DISTINCT cir.sup_ci_sequence_number || cir.sup_cal_type)
1638: FROM igs_he_st_spa_all spa ,
1639: igs_en_stdnt_ps_att sca,
1640: igs_en_su_attempt sua,
1641: igs_ca_inst_rel cir,
1642: igs_ca_inst_all ca
1643: WHERE SPA.person_id = p_person_id and
1644: SPA.student_inst_number = p_student_inst_number AND

Line 4068: FROM igs_en_su_attempt a,

4064: WHERE ihp.oss_org_unit_cd = p_inst_cd;
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

Line 4180: FROM igs_en_su_attempt a,

4176: -- anwest 09-Jun-05
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,

Line 4205: FROM igs_en_su_attempt a,

4201: AND a.ci_start_dt BETWEEN p_enrl_start_dt AND p_enrl_end_dt ;
4202:
4203: CURSOR c_total_cp IS
4204: SELECT SUM( NVL(override_enrolled_cp,NVL(cps.enrolled_credit_points,e.enrolled_credit_points))) Total_credit_points
4205: FROM igs_en_su_attempt a,
4206: igs_ps_unit_ver e,
4207: igs_ps_usec_cps cps,
4208: igs_he_st_unt_vs_all hunt
4209: WHERE a.course_cd = p_course_cd

Line 4398: FROM igs_en_su_attempt a ,

4394:
4395: --smaddali modified this cursor to consider unit level credit points also for bug 2415811
4396: CURSOR c_cp IS
4397: SELECT SUM( NVL(override_enrolled_cp,NVL(cps.enrolled_credit_points,b.enrolled_credit_points)) ) credit_points, b.unit_level
4398: FROM igs_en_su_attempt a ,
4399: igs_ps_unit_ver b,
4400: igs_ps_usec_cps cps,
4401: igs_he_st_unt_vs_all hunt
4402: WHERE a.course_cd = p_course_cd

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 6178: CURSOR c_outdt (p_unit_cd igs_en_su_attempt.unit_cd%TYPE)

6174: AND NVL(d.exclude_flag, 'N') = 'N'
6175: AND a.unit_attempt_status IN ('ENROLLED','DISCONTIN','COMPLETED')
6176: ORDER BY enrolled_credit_point DESC;
6177:
6178: CURSOR c_outdt (p_unit_cd igs_en_su_attempt.unit_cd%TYPE)
6179: IS
6180: SELECT sua.course_cd,
6181: sua.cal_type,
6182: sua.ci_sequence_number,

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