APPS.IGS_AD_IMP_003 dependencies on IGS_OR_INST_STAT

Line 703: FROM igs_or_inst_stat

699: WHERE a.institution_cd = b.party_number -- 5386694 (was wrongly compared with "ou_institution_cd" from the bug 4947103)
700: AND b.inst_org_ind = 'I'
701: AND institution_status IN
702: (SELECT institution_status
703: FROM igs_or_inst_stat
704: WHERE s_institution_status = 'ACTIVE')
705: );
706:
707: FOR l_oth_inst_rec IN c_oth_inst LOOP