389: || (reverse chronological order - newest change first)
390: */
391: CURSOR cur_sub_uoo(cp_n_uoo_id IN NUMBER) IS
392: SELECT sub.sup_uoo_id
393: FROM igs_ps_unit_ofr_opt sub
394: WHERE sub.uoo_id = cp_n_uoo_id ;
395: l_sup_uoo_id igs_ps_unit_ofr_opt.sup_uoo_id%TYPE;
396:
397: BEGIN
391: CURSOR cur_sub_uoo(cp_n_uoo_id IN NUMBER) IS
392: SELECT sub.sup_uoo_id
393: FROM igs_ps_unit_ofr_opt sub
394: WHERE sub.uoo_id = cp_n_uoo_id ;
395: l_sup_uoo_id igs_ps_unit_ofr_opt.sup_uoo_id%TYPE;
396:
397: BEGIN
398:
399: set_column_values (