DBA Data[Home] [Help]

APPS.IGS_HE_IMPORT_DATA dependencies on IGS_HE_UT_LVL_AWARD

Line 1366: CURSOR cur_ut_award_map ( cp_calc_type IGS_HE_UT_LVL_AWARD.tariff_calc_type_cd%TYPE,

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
1368: SELECT utla.award_cd
1369: FROM IGS_HE_UT_LVL_AWARD utla
1370: WHERE utla.tariff_calc_type_cd = cp_calc_type

Line 1367: cp_tariff_level_cd IGS_HE_UT_LVL_AWARD.tariff_level_cd%TYPE ) IS

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
1368: SELECT utla.award_cd
1369: FROM IGS_HE_UT_LVL_AWARD utla
1370: WHERE utla.tariff_calc_type_cd = cp_calc_type
1371: AND utla.tariff_level_cd = cp_tariff_level_cd

Line 1369: FROM IGS_HE_UT_LVL_AWARD utla

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
1368: SELECT utla.award_cd
1369: FROM IGS_HE_UT_LVL_AWARD utla
1370: WHERE utla.tariff_calc_type_cd = cp_calc_type
1371: AND utla.tariff_level_cd = cp_tariff_level_cd
1372: AND utla.default_award_ind = 'Y'
1373: AND utla.closed_ind = 'N' ;

Line 1376: l_oss_gceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

1372: AND utla.default_award_ind = 'Y'
1373: AND utla.closed_ind = 'N' ;
1374:
1375: -- smaddali added these local variables to hold OSS Award code for each HESA UT qualification ,bug#2671022
1376: l_oss_gceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1377: l_oss_vceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

Line 1377: l_oss_vceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

1373: AND utla.closed_ind = 'N' ;
1374:
1375: -- smaddali added these local variables to hold OSS Award code for each HESA UT qualification ,bug#2671022
1376: l_oss_gceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1377: l_oss_vceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

Line 1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

1374:
1375: -- smaddali added these local variables to hold OSS Award code for each HESA UT qualification ,bug#2671022
1376: l_oss_gceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1377: l_oss_vceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

Line 1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

1375: -- smaddali added these local variables to hold OSS Award code for each HESA UT qualification ,bug#2671022
1376: l_oss_gceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1377: l_oss_vceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

Line 1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

1376: l_oss_gceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1377: l_oss_vceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

Line 1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

1377: l_oss_vceasn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

Line 1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

1378: l_oss_gcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1386: l_oss_scsn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

Line 1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

1379: l_oss_vcean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1386: l_oss_scsn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1387: l_oss_aean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

Line 1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

1380: l_oss_ksqn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1386: l_oss_scsn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1387: l_oss_aean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1388: l_call_pers_imp BOOLEAN ;

Line 1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

1381: l_oss_uksan IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1386: l_oss_scsn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1387: l_oss_aean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1388: l_call_pers_imp BOOLEAN ;
1389: l_return_status VARCHAR2(1);

Line 1386: l_oss_scsn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

1382: l_oss_sahn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1386: l_oss_scsn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1387: l_oss_aean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1388: l_call_pers_imp BOOLEAN ;
1389: l_return_status VARCHAR2(1);
1390: l_msg_data VARCHAR2(100);

Line 1387: l_oss_aean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;

1383: l_oss_shn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1384: l_oss_si2n IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1385: l_oss_ssgcn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1386: l_oss_scsn IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1387: l_oss_aean IGS_HE_UT_LVL_AWARD.award_cd%TYPE;
1388: l_call_pers_imp BOOLEAN ;
1389: l_return_status VARCHAR2(1);
1390: l_msg_data VARCHAR2(100);
1391: