APPS.WIP_EAM_WRAPPROVAL_PVT dependencies on BOM_EAM_DEPT_APPROVERS

Line 59: bom_eam_dept_approvers beda

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

Line 68: from bom_eam_dept_approvers beda, fnd_user fu

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