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_UCAS_TARIFF_PKG dependencies on IGS_AS_GRD_SCH_GRADE

Line 81: -- inorder to calculate ucas_tariff on the fly added the join with igs_as_grd_sch_grade

77: -- get all the records for passed exam level of the student where year of qualification is null or
78: -- less than spa commencement date
79: -- smaddali added nvl to Year to get field ucas_tariff ,for bug 2415679
80: -- smaddali modified this cursor for bug 2473397 ,
81: -- inorder to calculate ucas_tariff on the fly added the join with igs_as_grd_sch_grade
82: -- Modified the cursor to exclude excluded subjects and subjects that are excluded specifically for this award.
83: -- Modified the cursor to add subject_code IS NULL for 3224610
84: CURSOR Cur_qual_dets (cp_person_id Igs_uc_qual_dets.person_id%TYPE,
85: cp_commencement_date Igs_en_stdnt_ps_att.Commencement_dt%TYPE,

Line 92: igs_as_grd_sch_grade grd

88: SELECT uqd.Exam_level,
89: uqd.Subject_code,
90: MAX(grd.rank) ucas_tariff
91: FROM igs_uc_qual_dets uqd,
92: igs_as_grd_sch_grade grd
93: WHERE uqd.Person_id = cp_person_id
94: AND uqd.Exam_level = cp_exam_level
95: AND grd.grade = uqd.approved_result
96: AND grd.grading_schema_cd = uqd.grading_schema_cd

Line 229: Igs_as_grd_sch_grade_v Iagsgv,

225: Iagsgv.full_grade_name, -- jchin 3484372 Added full grade name to output to log file
226: Iagsgv.rank
227: FROM Igs_uc_qual_dets Iuqd,
228: Igs_as_grd_sch_trn_all Iagsta,
229: Igs_as_grd_sch_grade_v Iagsgv,
230: Igs_as_grd_sch_grade grd
231: WHERE Iuqd.person_id = l_person_id
232: AND Iagsta.grading_schema_cd = Iuqd.grading_schema_cd
233: AND Iagsta.version_number = Iuqd.version_number

Line 230: Igs_as_grd_sch_grade grd

226: Iagsgv.rank
227: FROM Igs_uc_qual_dets Iuqd,
228: Igs_as_grd_sch_trn_all Iagsta,
229: Igs_as_grd_sch_grade_v Iagsgv,
230: Igs_as_grd_sch_grade grd
231: WHERE Iuqd.person_id = l_person_id
232: AND Iagsta.grading_schema_cd = Iuqd.grading_schema_cd
233: AND Iagsta.version_number = Iuqd.version_number
234: AND grd.grading_schema_cd = iuqd.grading_schema_cd

Line 824: -- igs_as_grd_sch_grade is joined as UCAS Tariff is obtained/derived on the fly.

820: AND eqas.field_of_study IS NOT NULL);
821:
822:
823: -- get all the valid subject records as per setup for passed exam level of the student and person.
824: -- igs_as_grd_sch_grade is joined as UCAS Tariff is obtained/derived on the fly.
825: -- The subquery is used to exclude excluded subjects and subjects that are excluded specifically for this award.
826: -- Modified the cursor to add subject_code IS NULL for 3224610
827: CURSOR get_tariff_cur (cp_person_id Igs_uc_qual_dets.person_id%TYPE,
828: cp_exam_level Igs_uc_qual_dets.Exam_level%TYPE,

Line 834: igs_as_grd_sch_grade grd

830: SELECT uqd.Exam_level,
831: uqd.Subject_code,
832: MAX(grd.rank) ucas_tariff
833: FROM igs_uc_qual_dets uqd,
834: igs_as_grd_sch_grade grd
835: WHERE uqd.Person_id = cp_person_id
836: AND uqd.Exam_level = cp_exam_level
837: AND grd.grade = uqd.approved_result
838: AND grd.grading_schema_cd = uqd.grading_schema_cd

Line 1221: igs_as_grd_sch_grade grd

1217: SELECT uqd.Exam_level,
1218: uqd.Subject_code,
1219: MAX(grd.rank) ucas_tariff
1220: FROM igs_uc_qual_dets uqd,
1221: igs_as_grd_sch_grade grd
1222: WHERE uqd.Person_id = cp_person_id
1223: AND uqd.Exam_level = cp_exam_level
1224: AND grd.grade = uqd.approved_result
1225: AND grd.grading_schema_cd = uqd.grading_schema_cd