APPS.IGS_AD_IMP_003 dependencies on IGS_AD_OTHER_INST

Line 684: AND EXISTS (SELECT 1 FROM igs_ad_other_inst b

680: error_text = l_error_text1
681: WHERE
682: interface_run_id = p_interface_run_id
683: AND status = '2'
684: AND EXISTS (SELECT 1 FROM igs_ad_other_inst b
685: WHERE b.person_id = a.person_id
686: AND b.admission_appl_number = a.admission_appl_number
687: AND b.institution_code = a.institution_cd );
688:

Line 738: igs_ad_other_inst_pkg.insert_row

734:
735: ELSE
736: l_rowid := NULL;
737:
738: igs_ad_other_inst_pkg.insert_row
739: (
740: x_rowid => l_rowid,
741: x_other_inst_id => l_oth_inst_id,
742: x_person_id => l_oth_inst_rec.person_id,