APPS.IGS_AS_ATT_WF_PKG dependencies on IGS_PS_USEC_TCH_RESP

Line 26: l_INSTRUCTOR_ID IGS_PS_USEC_TCH_RESP.INSTRUCTOR_ID%TYPE;

22:
23: l_api_name CONSTANT VARCHAR2(30) := 'Select_Approver' ;
24: l_return_status VARCHAR2(1);
25: l_uoo_id NUMBER(7) := wf_engine.getItemAttrText(itemtype, itemkey,'UOO_ID');
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

Line 32: FROM IGS_PS_USEC_TCH_RESP

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;
35:
36: CURSOR cur_user(lv_instructor_id igs_ps_usec_tch_resp.instructor_id%TYPE) IS

Line 36: CURSOR cur_user(lv_instructor_id igs_ps_usec_tch_resp.instructor_id%TYPE) IS

32: FROM IGS_PS_USEC_TCH_RESP
33: WHERE LEAD_INSTRUCTOR_FLAG = 'Y' AND
34: UOO_ID = lv_uoo_id;
35:
36: CURSOR cur_user(lv_instructor_id igs_ps_usec_tch_resp.instructor_id%TYPE) IS
37: SELECT user_name
38: FROM FND_USER
39: WHERE person_party_id = lv_instructor_id ;
40: