APPS.BIS_UTIL dependencies on FND_USER

Line 1958: FROM fnd_responsibility fnd_resp, fnd_menu_entries fnd_mnu_ent, fnd_user_resp_groups fnd_usr_resp

1954: IS
1955:
1956: CURSOR c_resp_id(l_menu_id NUMBER, l_user_id NUMBER) IS
1957: SELECT fnd_resp.responsibility_id
1958: FROM fnd_responsibility fnd_resp, fnd_menu_entries fnd_mnu_ent, fnd_user_resp_groups fnd_usr_resp
1959: WHERE fnd_resp.menu_id = fnd_mnu_ent.menu_id
1960: AND fnd_usr_resp.responsibility_id = fnd_resp.responsibility_id
1961: AND fnd_mnu_ent.menu_id = l_menu_id
1962: AND fnd_usr_resp.user_id = l_user_id

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: );

Line 2265: security group id for this combination from FND_USER_RESP_GROUPS_DIRECT

2261: END get_respId_for_measure_report;
2262:
2263: /*
2264: Takes as input user id and responsibility id, and returns the first
2265: security group id for this combination from FND_USER_RESP_GROUPS_DIRECT
2266: */
2267: FUNCTION get_sec_grp_id_for_user_role (
2268: p_resp_id IN NUMBER
2269: , p_user_id IN NUMBER

Line 2277: FROM fnd_user_resp_groups_direct

2273: l_sec_grp_id NUMBER;
2274:
2275: CURSOR c_sec_grp_id IS
2276: SELECT security_group_id
2277: FROM fnd_user_resp_groups_direct
2278: WHERE user_id = p_user_id
2279: AND responsibility_id = p_resp_id
2280: AND rownum < 2;
2281: BEGIN