APPS.IGS_AS_ATT_WF_PKG dependencies on IGS_PS_UNIT_OFR_OPT

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

26: l_INSTRUCTOR_ID IGS_PS_USEC_TCH_RESP.INSTRUCTOR_ID%TYPE;
27: l_user_name FND_USER.USER_NAME%TYPE;
28:
29:
30: CURSOR cur_instruct(lv_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
31: SELECT INSTRUCTOR_ID
32: FROM IGS_PS_USEC_TCH_RESP
33: WHERE LEAD_INSTRUCTOR_FLAG = 'Y' AND
34: UOO_ID = lv_uoo_id;