APPS.IGS_AS_ATT_WF_PKG dependencies on FND_USER

Line 27: l_user_name FND_USER.USER_NAME%TYPE;

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
31: SELECT INSTRUCTOR_ID

Line 38: FROM FND_USER

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:
41:
42: BEGIN