APPS.BIS_PMV_UTIL dependencies on FND_RESP_FUNCTIONS

Line 636: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF

632: l_menu_id fnd_responsibility.menu_id%TYPE;
633: l_user_id fnd_user.user_id%TYPE;
634: CURSOR CM IS
635: SELECT 1
636: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF
637: WHERE MEV.MENU_ID = l_menu_id
638: AND RF.RESPONSIBILITY_ID (+) = l_resp_id
639: AND RF.RULE_TYPE(+) = DECODE(MEV.FUNCTION_ID, NULL, 'M', 'F')
640: AND RF.ACTION_ID(+) <> DECODE(DECODE(MEV.FUNCTION_ID, NULL, 'M', 'F'), 'F', MEV.FUNCTION_ID,

Line 648: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF

644: AND FF.function_name = l_function_name
645: AND RF.APPLICATION_ID(+) = l_appl_id
646: UNION
647: SELECT 1
648: FROM FND_MENU_ENTRIES MEV, FND_RESP_FUNCTIONS RF, FND_FORM_FUNCTIONS FF
649: WHERE MEV.MENU_ID IN(
650: SELECT SUB_MENU_ID
651: FROM FND_MENU_ENTRIES
652: WHERE SUB_MENU_ID IS NOT NULL