92: -- at the unit level for the logged on person and for the uoo_id passed
93: CURSOR cur_usec_disc_dl
94: IS
95: SELECT usec_disc_dl_date alias_val
96: FROM igs_en_usec_disc_dl
97: WHERE uoo_id = p_uoo_id
98: ORDER BY usec_disc_dl_date, administrative_unit_status;
99:
100: -- cursor for getting the date aliases that are defined
339: -- at the unit level for the logged on person and for the uoo_id passed
340: CURSOR cur_unit_usec_disc
341: IS
342: SELECT usec_disc_dl_date alias_val,administrative_unit_status
343: FROM igs_en_usec_disc_dl
344: WHERE uoo_id = p_uoo_id
345: ORDER BY usec_disc_dl_date;
346:
347: -- cursor for getting the date aliases that are defined