APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_OR_ORG_ALT_IDTYP

Line 5798: FROM igs_or_org_alt_ids oai,igs_or_org_alt_idtyp oait

5794:
5795: -- MODIFIED THE CURSOR ASA PART OF ENH#3291662 BUILD.
5796: CURSOR c_heinst (p_inst_cd VARCHAR2 ) IS
5797: SELECT org_alternate_id
5798: FROM igs_or_org_alt_ids oai,igs_or_org_alt_idtyp oait
5799: WHERE oai.org_structure_id = p_inst_cd
5800: AND oai.org_structure_type = 'INSTITUTE'
5801: AND oai.org_alternate_id_type = oait.org_alternate_id_type
5802: AND oait.system_id_type = 'HESA_INST'