APPS.BIS_UTIL dependencies on WF_ROLE_LOV_VL

Line 691: select name from wf_role_lov_vl

687: l_wf_item_key NUMBER;
688: l_role_name VARCHAR2(80);
689:
690: CURSOR c_role_name IS
691: select name from wf_role_lov_vl
692: where name = p_notify_resp_name;
693:
694: BEGIN
695:

Line 2079: FROM fnd_responsibility fnd_resp, wf_role_lov_vl wf

2075: IS
2076: l_resp_id NUMBER;
2077: CURSOR c_resp(p_owner VARCHAR2) IS
2078: SELECT fnd_resp.responsibility_id
2079: FROM fnd_responsibility fnd_resp, wf_role_lov_vl wf
2080: WHERE fnd_resp.responsibility_id = wf.orig_system_id
2081: AND wf.name = p_owner
2082: AND wf.orig_system like 'FND_RESP%'
2083: AND rownum < 2; -- Just to avoid any failure here.

Line 2122: FROM fnd_user fnd_usr, wf_role_lov_vl wf

2118: IS
2119: l_user_id NUMBER;
2120: CURSOR c_user(p_owner VARCHAR2) IS
2121: SELECT fnd_usr.user_id
2122: FROM fnd_user fnd_usr, wf_role_lov_vl wf
2123: WHERE wf.name = p_owner
2124: AND ((wf.orig_system = 'FND_USR' AND fnd_usr.user_id = wf.orig_system_id) OR
2125: (wf.orig_system = 'PER' AND fnd_usr.employee_id = wf.orig_system_id)
2126: );