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_LVL_AWARD

Line 116: cp_tariff_calc_type igs_he_ut_lvl_award.tariff_calc_type_cd%TYPE) IS

112: -- (both Award is not null and subject is not null in exclude qualifications table).
113: -- Modified the cursor to add subject_code IS NULL for 3224610
114: CURSOR Cur_exam_level (l_person_id igs_uc_qual_dets.person_id%TYPE,
115: l_commencement_date Igs_en_stdnt_ps_att. Commencement_dt%TYPE,
116: cp_tariff_calc_type igs_he_ut_lvl_award.tariff_calc_type_cd%TYPE) IS
117: SELECT DISTINCT Exam_level
118: FROM Igs_uc_qual_dets
119: WHERE Person_id = l_person_id
120: AND exam_level IN (SELECT hula.award_cd

Line 121: FROM igs_he_ut_lvl_award hula

117: SELECT DISTINCT Exam_level
118: FROM Igs_uc_qual_dets
119: WHERE Person_id = l_person_id
120: AND exam_level IN (SELECT hula.award_cd
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

Line 257: cp_tariff_calc_type igs_he_ut_lvl_award.tariff_calc_type_cd%TYPE) IS

253: CURSOR cur_check_dup_awards (cp_person_id igs_uc_qual_dets.person_id%TYPE,
254: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,
255: cp_subject_cd igs_uc_qual_dets.subject_code%TYPE,
256: cp_commencement_date igs_en_stdnt_ps_att.commencement_dt%TYPE,
257: cp_tariff_calc_type igs_he_ut_lvl_award.tariff_calc_type_cd%TYPE) IS
258: SELECT DISTINCT exam_level
259: FROM igs_uc_qual_dets
260: WHERE person_id = cp_person_id
261: AND exam_level <> cp_exam_level

Line 264: FROM igs_he_ut_lvl_award hula

260: WHERE person_id = cp_person_id
261: AND exam_level <> cp_exam_level
262: AND subject_code = cp_subject_cd
263: AND exam_level IN (SELECT hula.award_cd
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

Line 799: cp_tariff_calc_type igs_he_ut_lvl_award.tariff_calc_type_cd%TYPE)

795: -- Subquery4 is to filter out Award + subject combination records which are setup for exclusion i.e.
796: -- (both Award is not null and subject is not null in exclude qualifications table).
797: -- Modified the cursor to add subject_code IS NULL for 3224610
798: CURSOR prsn_exam_level_cur (cp_person_id igs_uc_qual_dets.person_id%TYPE,
799: cp_tariff_calc_type igs_he_ut_lvl_award.tariff_calc_type_cd%TYPE)
800: IS
801: SELECT DISTINCT exam_level
802: FROM igs_uc_qual_dets
803: WHERE person_id = cp_person_id

Line 805: FROM igs_he_ut_lvl_award hula

801: SELECT DISTINCT exam_level
802: FROM igs_uc_qual_dets
803: WHERE person_id = cp_person_id
804: AND exam_level IN (SELECT hula.award_cd
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

Line 851: cp_tariff_calc_type igs_he_ut_lvl_award.tariff_calc_type_cd%TYPE) IS

847: -- cursor to get records for the passed subject with other exam levels
848: CURSOR cur_check_dup_awards (cp_person_id igs_uc_qual_dets.person_id%TYPE,
849: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,
850: cp_subject_cd igs_uc_qual_dets.subject_code%TYPE,
851: cp_tariff_calc_type igs_he_ut_lvl_award.tariff_calc_type_cd%TYPE) IS
852: SELECT DISTINCT exam_level
853: FROM igs_uc_qual_dets
854: WHERE person_id = cp_person_id
855: AND exam_level <> cp_exam_level

Line 858: FROM igs_he_ut_lvl_award hula

854: WHERE person_id = cp_person_id
855: AND exam_level <> cp_exam_level
856: AND subject_code = cp_subject_cd
857: AND exam_level IN (SELECT hula.award_cd
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

Line 1237: cp_tariff_calc_type igs_he_ut_lvl_award.tariff_calc_type_cd%TYPE) IS

1233: -- cursor to get records for the passed subject with other exam levels
1234: CURSOR cur_check_dup_awards (cp_person_id igs_uc_qual_dets.person_id%TYPE,
1235: cp_exam_level igs_uc_qual_dets.exam_level%TYPE,
1236: cp_subject_cd igs_uc_qual_dets.subject_code%TYPE,
1237: cp_tariff_calc_type igs_he_ut_lvl_award.tariff_calc_type_cd%TYPE) IS
1238: SELECT DISTINCT exam_level
1239: FROM igs_uc_qual_dets
1240: WHERE person_id = cp_person_id
1241: AND exam_level <> cp_exam_level

Line 1244: FROM igs_he_ut_lvl_award hula

1240: WHERE person_id = cp_person_id
1241: AND exam_level <> cp_exam_level
1242: AND subject_code = cp_subject_cd
1243: AND exam_level IN (SELECT hula.award_cd
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