APPS.BIS_UTIL dependencies on FND_RESPONSIBILITY

Line 1918: l_resp_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;

1914: AND fnd_ff.function_name = p_function_name;
1915: l_menu_id_rec c_menu_id%ROWTYPE;
1916:
1917: l_function_id FND_FORM_FUNCTIONS.FUNCTION_ID%TYPE;
1918: l_resp_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
1919:
1920: BEGIN
1921:
1922: IF (p_function_name IS NOT NULL) THEN

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 1975: l_resp_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;

1971: FROM fnd_menu_entries
1972: WHERE sub_menu_id = l_sub_menu_id;
1973: l_sub_menu_id_rec c_sub_menu_id%ROWTYPE;
1974:
1975: l_resp_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
1976: l_count NUMBER;
1977:
1978: BEGIN
1979:

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.