APPS.WIP_EAM_WRAPPROVAL_PVT dependencies on BOM_EAM_DEPT_APPROVERS

Line 63: bom_eam_dept_approvers beda

59: -- now the user is able to select other depts in beda
60: cursor c_role_name is
61: select wfr.NAME
62: from wf_roles wfr ,
63: bom_eam_dept_approvers beda
64: where
65: beda.dept_id = p_work_request_owning_dept_id
66: and beda.organization_id = p_organization_id
67: and beda.responsibility_id = wfr.orig_system_id ;

Line 72: from bom_eam_dept_approvers beda, fnd_user fu

68: */
69:
70: cursor c_resp_name is
71: select beda.responsibility_id,beda.responsibility_application_id,fu.user_name
72: from bom_eam_dept_approvers beda, fnd_user fu
73: where
74: beda.dept_id = p_work_request_owning_dept_id
75: and beda.organization_id = p_organization_id
76: and fu.user_id(+) = beda.primary_approver_id;