APPS.IGS_AD_IMP_003 dependencies on IGS_PS_FLD_OF_STUDY_ALL

Line 137: FROM igs_ps_fld_of_study_all b

133: error_text = l_error_text1
134: WHERE interface_run_id = p_interface_run_id
135: AND status = '2'
136: AND NOT EXISTS ( SELECT 'X'
137: FROM igs_ps_fld_of_study_all b
138: WHERE b.field_of_study = a.field_of_study
139: AND b.closed_ind = 'N' );
140:
141: FOR c_acadint_rec IN c_acadint LOOP