APPS.IGS_HE_UCAS_TARIFF_PKG dependencies on IGS_HE_UT_PRT_AWARD

Line 274: CURSOR cur_check_parent (cp_award_cd igs_he_ut_prt_award.award_cd%TYPE,

270: AND hueq.field_of_study IS NULL)
271: AND (year IS NULL OR Year <= TO_CHAR(cp_commencement_date, 'YYYY'));
272:
273: -- For checking whether parent award exists for the passed in award.
274: CURSOR cur_check_parent (cp_award_cd igs_he_ut_prt_award.award_cd%TYPE,
275: cp_tariff_calc_type igs_he_ut_prt_award.tariff_calc_type_cd%TYPE) IS
276: SELECT parent_award_cd
277: FROM (SELECT *
278: FROM igs_he_ut_prt_award

Line 275: cp_tariff_calc_type igs_he_ut_prt_award.tariff_calc_type_cd%TYPE) IS

271: AND (year IS NULL OR Year <= TO_CHAR(cp_commencement_date, 'YYYY'));
272:
273: -- For checking whether parent award exists for the passed in award.
274: CURSOR cur_check_parent (cp_award_cd igs_he_ut_prt_award.award_cd%TYPE,
275: cp_tariff_calc_type igs_he_ut_prt_award.tariff_calc_type_cd%TYPE) IS
276: SELECT parent_award_cd
277: FROM (SELECT *
278: FROM igs_he_ut_prt_award
279: WHERE tariff_calc_type_cd = cp_tariff_calc_type)

Line 278: FROM igs_he_ut_prt_award

274: CURSOR cur_check_parent (cp_award_cd igs_he_ut_prt_award.award_cd%TYPE,
275: cp_tariff_calc_type igs_he_ut_prt_award.tariff_calc_type_cd%TYPE) IS
276: SELECT parent_award_cd
277: FROM (SELECT *
278: FROM igs_he_ut_prt_award
279: WHERE tariff_calc_type_cd = cp_tariff_calc_type)
280: START WITH award_cd = cp_award_cd
281: CONNECT BY PRIOR parent_award_cd = award_cd
282: AND tariff_calc_type_cd = cp_tariff_calc_type;

Line 867: CURSOR cur_check_parent (cp_award_cd igs_he_ut_prt_award.award_cd%TYPE,

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.
867: CURSOR cur_check_parent (cp_award_cd igs_he_ut_prt_award.award_cd%TYPE,
868: cp_tariff_calc_type igs_he_ut_prt_award.tariff_calc_type_cd%TYPE) IS
869: SELECT parent_award_cd
870: FROM ( SELECT *
871: FROM igs_he_ut_prt_award

Line 868: cp_tariff_calc_type igs_he_ut_prt_award.tariff_calc_type_cd%TYPE) IS

864: AND hueq.field_of_study IS NULL);
865:
866: -- Cursor for checking whether parent award exists for the passed in award.
867: CURSOR cur_check_parent (cp_award_cd igs_he_ut_prt_award.award_cd%TYPE,
868: cp_tariff_calc_type igs_he_ut_prt_award.tariff_calc_type_cd%TYPE) IS
869: SELECT parent_award_cd
870: FROM ( SELECT *
871: FROM igs_he_ut_prt_award
872: WHERE tariff_calc_type_cd = cp_tariff_calc_type)

Line 871: FROM igs_he_ut_prt_award

867: CURSOR cur_check_parent (cp_award_cd igs_he_ut_prt_award.award_cd%TYPE,
868: cp_tariff_calc_type igs_he_ut_prt_award.tariff_calc_type_cd%TYPE) IS
869: SELECT parent_award_cd
870: FROM ( SELECT *
871: FROM igs_he_ut_prt_award
872: WHERE tariff_calc_type_cd = cp_tariff_calc_type)
873: START WITH award_cd = cp_award_cd
874: CONNECT BY PRIOR parent_award_cd=award_cd
875: AND tariff_calc_type_cd = cp_tariff_calc_type;

Line 1253: CURSOR cur_check_parent (cp_award_cd igs_he_ut_prt_award.award_cd%TYPE,

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.
1253: CURSOR cur_check_parent (cp_award_cd igs_he_ut_prt_award.award_cd%TYPE,
1254: cp_tariff_calc_type igs_he_ut_prt_award.tariff_calc_type_cd%TYPE) IS
1255: SELECT parent_award_cd
1256: FROM ( SELECT *
1257: FROM igs_he_ut_prt_award

Line 1254: cp_tariff_calc_type igs_he_ut_prt_award.tariff_calc_type_cd%TYPE) IS

1250: AND hueq.field_of_study IS NULL);
1251:
1252: -- Cursor for checking whether parent award exists for the passed in award.
1253: CURSOR cur_check_parent (cp_award_cd igs_he_ut_prt_award.award_cd%TYPE,
1254: cp_tariff_calc_type igs_he_ut_prt_award.tariff_calc_type_cd%TYPE) IS
1255: SELECT parent_award_cd
1256: FROM ( SELECT *
1257: FROM igs_he_ut_prt_award
1258: WHERE tariff_calc_type_cd = cp_tariff_calc_type)

Line 1257: FROM igs_he_ut_prt_award

1253: CURSOR cur_check_parent (cp_award_cd igs_he_ut_prt_award.award_cd%TYPE,
1254: cp_tariff_calc_type igs_he_ut_prt_award.tariff_calc_type_cd%TYPE) IS
1255: SELECT parent_award_cd
1256: FROM ( SELECT *
1257: FROM igs_he_ut_prt_award
1258: WHERE tariff_calc_type_cd = cp_tariff_calc_type)
1259: START WITH award_cd = cp_award_cd
1260: CONNECT BY PRIOR parent_award_cd=award_cd
1261: AND tariff_calc_type_cd = cp_tariff_calc_type;