APPS.IGS_HE_IMPORT_DATA dependencies on IGS_HE_UT_CALC_TYPE

Line 1360: FROM IGS_HE_UT_CALC_TYPE utct

1356:
1357: -- To get the External Calculation Type used for UCAS Tariff Calculation
1358: CURSOR cur_calc_type IS
1359: SELECT utct.tariff_calc_type_cd
1360: FROM IGS_HE_UT_CALC_TYPE utct
1361: WHERE utct.external_calc_ind = 'Y'
1362: AND utct.closed_ind = 'N' ;
1363: l_tariff_calc_type_cd IGS_HE_UT_CALC_TYPE.tariff_calc_type_cd%TYPE ;
1364:

Line 1363: l_tariff_calc_type_cd IGS_HE_UT_CALC_TYPE.tariff_calc_type_cd%TYPE ;

1359: SELECT utct.tariff_calc_type_cd
1360: FROM IGS_HE_UT_CALC_TYPE utct
1361: WHERE utct.external_calc_ind = 'Y'
1362: AND utct.closed_ind = 'N' ;
1363: l_tariff_calc_type_cd IGS_HE_UT_CALC_TYPE.tariff_calc_type_cd%TYPE ;
1364:
1365: -- To get the Default OSS Ward mapped to a HESA Tariff Level
1366: CURSOR cur_ut_award_map ( cp_calc_type IGS_HE_UT_LVL_AWARD.tariff_calc_type_cd%TYPE,
1367: cp_tariff_level_cd IGS_HE_UT_LVL_AWARD.tariff_level_cd%TYPE ) IS