APPS.IGS_AD_IMP_003 dependencies on IGS_AD_ACAD_INTEREST

Line 123: AND EXISTS (SELECT 1 FROM igs_ad_acad_interest b

119: error_text = l_error_text1
120: WHERE
121: interface_run_id = p_interface_run_id
122: AND status = '2'
123: AND EXISTS (SELECT 1 FROM igs_ad_acad_interest b
124: WHERE b.person_id = a.person_id
125: AND b.admission_appl_number = a.admission_appl_number
126: AND b.field_of_study = a.field_of_study );
127:

Line 172: igs_ad_acad_interest_pkg.insert_row

168: l_error_text1 := NULL;
169:
170: ELSE
171: l_rowid := NULL;
172: igs_ad_acad_interest_pkg.insert_row
173: (
174: x_rowid => l_rowid,
175: x_acad_interest_id => l_acad_int_id,
176: x_person_id => c_acadint_rec.person_id ,