APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_UC_REF_TARIFF

Line 1265: FROM igs_uc_ref_tariff rtrf

1261: CURSOR old_reftariff_cur (p_examlevel igs_uc_ctariff_ints.examlevel%TYPE,
1262: p_examgrade igs_uc_ctariff_ints.examgrade%TYPE) IS
1263: SELECT rtrf.rowid,
1264: rtrf.*
1265: FROM igs_uc_ref_tariff rtrf
1266: WHERE rtrf.exam_level = p_examlevel
1267: AND rtrf.exam_grade = p_examgrade;
1268:
1269: old_tariff_rec old_reftariff_cur%ROWTYPE;

Line 1311: igs_uc_ref_tariff_pkg.insert_row --

1307:
1308: -- If not found then insert
1309: IF old_tariff_rec.rowid IS NULL THEN
1310: BEGIN
1311: igs_uc_ref_tariff_pkg.insert_row --
1312: (
1313: x_rowid => old_tariff_rec.rowid
1314: ,x_exam_level => new_reftariff_rec.examlevel
1315: ,x_exam_grade => new_reftariff_rec.examgrade

Line 1329: igs_uc_ref_tariff_pkg.update_row --

1325: END;
1326:
1327: ELSE -- update
1328: BEGIN
1329: igs_uc_ref_tariff_pkg.update_row --
1330: (
1331: x_rowid => old_tariff_rec.rowid
1332: ,x_exam_level => old_tariff_rec.exam_level
1333: ,x_exam_grade => old_tariff_rec.exam_grade