APPS.IGS_HE_IMPORT_DATA dependencies on DUAL

Line 1256: FROM dual;

1252:
1253: -- Get the Batch ID for admission application import process
1254: CURSOR c_bat_id IS
1255: SELECT igs_ad_interface_batch_id_s.NEXTVAL
1256: FROM dual;
1257:
1258: -- Get the Source type ID of UCAS for admission import process
1259: --smaddali modified this cursor to get the source type UCAS PER instead of UCAS APPL ,bug 2724140
1260: CURSOR c_src_type_id IS

Line 2170: -- If total tariff is given without individual tariffs present , then log error

2166: END IF; /* End of checking the UCAS Tariff Calculation Setup exist */
2167:
2168: END IF ; /* End of validating the UCAS Tariff related fields */
2169:
2170: -- If total tariff is given without individual tariffs present , then log error
2171: IF c_interface_rec.total_ucas_tariff IS NOT NULL AND c_interface_rec.aeats IS NULL AND
2172: c_interface_rec.scsts IS NULL AND c_interface_rec.ssgcts IS NULL AND
2173: c_interface_rec.si2ts IS NULL AND c_interface_rec.shts IS NULL AND
2174: c_interface_rec.sahts IS NULL AND c_interface_rec.uksats IS NULL AND