APPS.IGS_UC_QUAL_DETS_IMP_PKG dependencies on IGS_OR_ORG_INST_TYPE

Line 656: igs_or_org_inst_type oit,

652: CURSOR cur_awd_body IS
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'