[Home] [Help]
531: WHERE uoo_id = cp_n_uoo_id;
532:
533: CURSOR cur_permission_unit(cp_uoo_id IN NUMBER) IS
534: SELECT spl.spl_perm_request_id
535: FROM igs_en_spl_perm spl
536: WHERE spl.student_person_id= p_person_id
537: AND spl.uoo_id = cp_uoo_id
538: AND spl.transaction_type <> 'WITHDRAWN';
539: