APPS.IGS_UC_QUAL_DETS_IMP_PKG dependencies on IGS_OR_INST_STAT

Line 657: igs_or_inst_stat ois

653: SELECT 'X'
654: FROM hz_parties hp,
655: igs_pe_hz_parties ihp,
656: igs_or_org_inst_type oit,
657: igs_or_inst_stat ois
658: WHERE hp.party_id = ihp.party_id
659: AND ihp.oss_org_unit_cd = p_uc_qual_cur.awarding_body
660: AND hp.status = 'A'
661: AND ihp.oi_institution_status = ois.institution_status (+)