[Home] [Help]
449:
450: -- Cursor to get the org_structure_id for the passed alternate code
451: CURSOR c_school_code IS
452: SELECT alt.org_structure_id
453: FROM igs_or_org_alt_ids alt, igs_or_institution inst
454: WHERE alt.org_structure_id = inst.institution_cd
455: AND alt.org_structure_type = 'INSTITUTE'
456: AND NVL(alt.end_date, SYSDATE) >= SYSDATE
457: AND inst.local_institution_ind = 'Y'