APPS.IGS_AS_CGR_WF_PKG dependencies on IGS_PS_UNIT_OFR_OPT

Line 38: CURSOR cur_instruct (lv_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

34: CURSOR cur_user (lv_requester_id fnd_user.person_party_id%TYPE) IS
35: SELECT user_name
36: FROM fnd_user
37: WHERE person_party_id = lv_requester_id;
38: CURSOR cur_instruct (lv_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
39: SELECT instructor_id
40: FROM igs_ps_usec_tch_resp
41: WHERE lead_instructor_flag = 'Y'
42: AND uoo_id = lv_uoo_id;