DBA Data[Home] [Help]

APPS.IGS_DA_TRNS_IMP dependencies on IGS_OR_ORG_INST_TYPE_ALL

Line 107: igs_or_org_inst_type_all oit

103: IS
104: SELECT hp.ROWID row_id
105: FROM hz_parties p,
106: igs_pe_hz_parties hp,
107: igs_or_org_inst_type_all oit
108: WHERE hp.party_id = p.party_id
109: AND hp.inst_org_ind = 'I'
110: AND p.party_number = person_history_rec.prev_institution_code
111: AND hp.oi_institution_type = oit.institution_type(+)