APPS.IGS_AS_GR_WF_PKG dependencies on IGS_PS_USEC_TCH_RESP

Line 45: igs_ps_usec_tch_resp pur,

41: SELECT
42: pur.instructor_id instructor_id,
43: fu.user_name user_name
44: FROM
45: igs_ps_usec_tch_resp pur,
46: fnd_user fu
47: WHERE
48: fu.person_party_id = pur.instructor_id
49: AND

Line 56: l_INSTRUCTOR_ID IGS_PS_USEC_TCH_RESP.INSTRUCTOR_ID%TYPE;

52: pur.uoo_id = cp_uoo_id;
53:
54: l_api_name CONSTANT VARCHAR2(30) := 'Select_Approver' ;
55: l_return_status VARCHAR2(1);
56: l_INSTRUCTOR_ID IGS_PS_USEC_TCH_RESP.INSTRUCTOR_ID%TYPE;
57: l_UOO_ID NUMBER(7) := wf_engine.getItemAttrText(itemtype, itemkey,'UOO_ID');
58: rec_c_set_requestor C_SET_REQUESTOR%ROWTYPE;
59: rec_c_get_lead_instructor C_GET_LEAD_INSTRUCTOR%ROWTYPE;
60: