APPS.IGS_AD_IMP_003 dependencies on IGS_AD_SPL_TALENTS

Line 1177: AND EXISTS (SELECT 1 FROM igs_ad_spl_talents b

1173: error_text = l_error_text1
1174: WHERE
1175: interface_run_id = p_interface_run_id
1176: AND status = '2'
1177: AND EXISTS (SELECT 1 FROM igs_ad_spl_talents b
1178: WHERE b.person_id = a.person_id
1179: AND b.admission_appl_number = a.admission_appl_number
1180: AND b.special_talent_type_id = a.special_talent_type_id);
1181:

Line 1212: igs_ad_spl_talents_pkg.insert_row(

1208: l_error_text := NULL;
1209:
1210: ELSE
1211: l_rowid := NULL;
1212: igs_ad_spl_talents_pkg.insert_row(
1213: x_rowid => l_rowid,
1214: x_spl_talent_id => l_spl_tal_id,
1215: x_person_id => l_spl_tal_rec.person_id,
1216: x_admission_appl_number => l_spl_tal_rec.admission_appl_number ,