APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_OR_ORG_ALT_IDS

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'

Line 5819: l_org_alternate_id igs_or_org_alt_ids_v.org_alternate_id%TYPE;

5815:
5816: l_oss_inst_cd igs_ad_acad_history_v.institution_code%TYPE;
5817: l_year DATE;
5818: l_creation_date DATE;
5819: l_org_alternate_id igs_or_org_alt_ids_v.org_alternate_id%TYPE;
5820: l_govt_institution_cd igs_pe_hz_parties.oi_govt_institution_cd%TYPE;
5821: l_he_code_map_val igs_he_code_map_val%ROWTYPE;
5822:
5823: BEGIN