DBA Data[Home] [Help]

APPS.JTF_TASK_UTL dependencies on FND_MENUS

Line 3242: AND fme.menu_id = (select fm.menu_id from fnd_menus fm, fnd_grants fg

3238: THEN
3239: SELECT function_name into l_privilege
3240: FROM fnd_form_functions fff, fnd_menu_entries fme
3241: WHERE fff.function_id = fme.function_id
3242: AND fme.menu_id = (select fm.menu_id from fnd_menus fm, fnd_grants fg
3243: where fm.menu_id = fg.menu_id
3244: and fg.instance_pk1_value = l_owner_id
3245: and fg.instance_pk2_value = l_owner_type_code
3246: and fg.grantee_key = TO_CHAR(l_rs_id)

Line 3339: FROM fnd_menus fm

3335: FROM fnd_form_functions fff
3336: , fnd_menu_entries fme
3337: WHERE fff.function_id = fme.function_id
3338: AND fme.menu_id = (SELECT fm.menu_id
3339: FROM fnd_menus fm
3340: , fnd_grants fg
3341: WHERE fm.menu_id = fg.menu_id
3342: AND fg.instance_pk1_value = pc_pk1_value
3343: AND fg.instance_pk2_value = pc_pk2_value