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_HE_UT_EXCL_QALS

Line 87: cp_tariff_calc_type Igs_he_ut_excl_qals.tariff_calc_type_cd%TYPE) IS

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,
86: cp_exam_level Igs_uc_qual_dets.Exam_level%TYPE,
87: cp_tariff_calc_type Igs_he_ut_excl_qals.tariff_calc_type_cd%TYPE) IS
88: SELECT uqd.Exam_level,
89: uqd.Subject_code,
90: MAX(grd.rank) ucas_tariff
91: FROM igs_uc_qual_dets uqd,

Line 100: FROM igs_he_ut_excl_qals

96: AND grd.grading_schema_cd = uqd.grading_schema_cd
97: AND grd.version_number = uqd.version_number
98: AND ( uqd.Year IS NULL OR uqd.Year <= TO_CHAR (cp_commencement_date, 'YYYY'))
99: AND ( subject_code IS NULL OR subject_code NOT IN (SELECT field_of_study
100: FROM igs_he_ut_excl_qals
101: WHERE tariff_calc_type_cd = cp_tariff_calc_type
102: AND (award_cd IS NULL OR award_cd = cp_exam_level)))
103: GROUP BY Exam_level, Subject_code ;
104:

Line 125: FROM igs_he_ut_excl_qals hueq

121: FROM igs_he_ut_lvl_award hula
122: WHERE hula.tariff_calc_type_cd = cp_tariff_calc_type
123: AND hula.closed_ind = 'N')
124: AND exam_level NOT IN (SELECT hueq.award_cd
125: FROM igs_he_ut_excl_qals hueq
126: WHERE hueq.tariff_calc_type_cd = cp_tariff_calc_type
127: AND hueq.field_of_study IS NULL)
128: AND (subject_code IS NULL OR subject_code NOT IN (SELECT field_of_study
129: FROM igs_he_ut_excl_qals

Line 129: FROM igs_he_ut_excl_qals

125: FROM igs_he_ut_excl_qals hueq
126: WHERE hueq.tariff_calc_type_cd = cp_tariff_calc_type
127: AND hueq.field_of_study IS NULL)
128: AND (subject_code IS NULL OR subject_code NOT IN (SELECT field_of_study
129: FROM igs_he_ut_excl_qals
130: WHERE tariff_calc_type_cd = cp_tariff_calc_type
131: AND award_cd IS NULL))
132: AND (exam_level, subject_code) NOT IN (SELECT eqas.award_cd, eqas.field_of_study
133: FROM igs_he_ut_excl_qals eqas

Line 133: FROM igs_he_ut_excl_qals eqas

129: FROM igs_he_ut_excl_qals
130: WHERE tariff_calc_type_cd = cp_tariff_calc_type
131: AND award_cd IS NULL))
132: AND (exam_level, subject_code) NOT IN (SELECT eqas.award_cd, eqas.field_of_study
133: FROM igs_he_ut_excl_qals eqas
134: WHERE eqas.tariff_calc_type_cd = cp_tariff_calc_type
135: AND eqas.award_cd IS NOT NULL
136: AND eqas.field_of_study IS NOT NULL)
137: AND (Year IS NULL OR Year <= TO_CHAR (l_commencement_date, 'YYYY') ) ;

Line 268: FROM igs_he_ut_excl_qals hueq

264: FROM igs_he_ut_lvl_award hula
265: WHERE hula.tariff_calc_type_cd = cp_tariff_calc_type
266: AND hula.closed_ind = 'N')
267: AND exam_level NOT IN (SELECT hueq.award_cd
268: FROM igs_he_ut_excl_qals hueq
269: WHERE hueq.tariff_calc_type_cd = cp_tariff_calc_type
270: AND hueq.field_of_study IS NULL)
271: AND (year IS NULL OR Year <= TO_CHAR(cp_commencement_date, 'YYYY'));
272:

Line 809: FROM igs_he_ut_excl_qals hueq

805: FROM igs_he_ut_lvl_award hula
806: WHERE hula.tariff_calc_type_cd = cp_tariff_calc_type
807: AND hula.closed_ind = 'N')
808: AND exam_level NOT IN (SELECT hueq.award_cd
809: FROM igs_he_ut_excl_qals hueq
810: WHERE hueq.tariff_calc_type_cd = cp_tariff_calc_type
811: AND hueq.field_of_study IS NULL)
812: AND (subject_code IS NULL OR subject_code NOT IN (SELECT field_of_study
813: FROM igs_he_ut_excl_qals

Line 813: FROM igs_he_ut_excl_qals

809: FROM igs_he_ut_excl_qals hueq
810: WHERE hueq.tariff_calc_type_cd = cp_tariff_calc_type
811: AND hueq.field_of_study IS NULL)
812: AND (subject_code IS NULL OR subject_code NOT IN (SELECT field_of_study
813: FROM igs_he_ut_excl_qals
814: WHERE tariff_calc_type_cd = cp_tariff_calc_type
815: AND award_cd IS NULL))
816: AND (exam_level, subject_code) NOT IN (SELECT eqas.award_cd, eqas.field_of_study
817: FROM igs_he_ut_excl_qals eqas

Line 817: FROM igs_he_ut_excl_qals eqas

813: FROM igs_he_ut_excl_qals
814: WHERE tariff_calc_type_cd = cp_tariff_calc_type
815: AND award_cd IS NULL))
816: AND (exam_level, subject_code) NOT IN (SELECT eqas.award_cd, eqas.field_of_study
817: FROM igs_he_ut_excl_qals eqas
818: WHERE eqas.tariff_calc_type_cd = cp_tariff_calc_type
819: AND eqas.award_cd IS NOT NULL
820: AND eqas.field_of_study IS NOT NULL);
821:

Line 829: cp_tariff_calc_type Igs_he_ut_excl_qals.tariff_calc_type_cd%TYPE) IS

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,
829: cp_tariff_calc_type Igs_he_ut_excl_qals.tariff_calc_type_cd%TYPE) IS
830: SELECT uqd.Exam_level,
831: uqd.Subject_code,
832: MAX(grd.rank) ucas_tariff
833: FROM igs_uc_qual_dets uqd,

Line 841: FROM igs_he_ut_excl_qals

837: AND grd.grade = uqd.approved_result
838: AND grd.grading_schema_cd = uqd.grading_schema_cd
839: AND grd.version_number = uqd.version_number
840: AND (subject_code IS NULL OR subject_code NOT IN (SELECT field_of_study
841: FROM igs_he_ut_excl_qals
842: WHERE tariff_calc_type_cd = cp_tariff_calc_type
843: AND (award_cd IS NULL OR award_cd = cp_exam_level)))
844: GROUP BY uqd.Exam_level, uqd.Subject_code ;
845:

Line 862: FROM igs_he_ut_excl_qals hueq

858: FROM igs_he_ut_lvl_award hula
859: WHERE hula.tariff_calc_type_cd = cp_tariff_calc_type
860: AND hula.closed_ind = 'N')
861: AND exam_level NOT IN (SELECT hueq.award_cd
862: FROM igs_he_ut_excl_qals hueq
863: WHERE hueq.tariff_calc_type_cd = cp_tariff_calc_type
864: AND hueq.field_of_study IS NULL);
865:
866: -- Cursor for checking whether parent award exists for the passed in award.

Line 1216: cp_tariff_calc_type Igs_he_ut_excl_qals.tariff_calc_type_cd%TYPE) IS

1212: AND tariff_calc_type_cd = cp_calc_type;
1213:
1214: CURSOR get_tariff_cur (cp_person_id Igs_uc_qual_dets.person_id%TYPE,
1215: cp_exam_level Igs_uc_qual_dets.Exam_level%TYPE,
1216: cp_tariff_calc_type Igs_he_ut_excl_qals.tariff_calc_type_cd%TYPE) IS
1217: SELECT uqd.Exam_level,
1218: uqd.Subject_code,
1219: MAX(grd.rank) ucas_tariff
1220: FROM igs_uc_qual_dets uqd,

Line 1228: FROM igs_he_ut_excl_qals

1224: AND grd.grade = uqd.approved_result
1225: AND grd.grading_schema_cd = uqd.grading_schema_cd
1226: AND grd.version_number = uqd.version_number
1227: AND (subject_code IS NULL OR subject_code NOT IN (SELECT field_of_study
1228: FROM igs_he_ut_excl_qals
1229: WHERE tariff_calc_type_cd = cp_tariff_calc_type
1230: AND (award_cd IS NULL OR award_cd = cp_exam_level)))
1231: GROUP BY uqd.Exam_level, uqd.Subject_code ;
1232:

Line 1248: FROM igs_he_ut_excl_qals hueq

1244: FROM igs_he_ut_lvl_award hula
1245: WHERE hula.tariff_calc_type_cd = cp_tariff_calc_type
1246: AND hula.closed_ind = 'N')
1247: AND exam_level NOT IN (SELECT hueq.award_cd
1248: FROM igs_he_ut_excl_qals hueq
1249: WHERE hueq.tariff_calc_type_cd = cp_tariff_calc_type
1250: AND hueq.field_of_study IS NULL);
1251:
1252: -- Cursor for checking whether parent award exists for the passed in award.