DBA Data[Home] [Help]

APPS.IEX_CHECKLIST_UTILITY dependencies on FND_FORM_FUNCTIONS

Line 427: FROM fnd_resp_functions rf, fnd_form_functions ff

423: -- End fix bug #4930424-remove TABLE ACCESS FULL
424:
425: CURSOR c_funct(p_responsibility_id NUMBER, p_function_name VARCHAR2) IS
426: SELECT rf.action_id, ff.function_id
427: FROM fnd_resp_functions rf, fnd_form_functions ff
428: WHERE rf.responsibility_id(+) = p_responsibility_id
429: AND ff.function_name = p_function_name
430: AND rf.action_id(+) = ff.function_id
431: AND rf.rule_type(+) = 'F';

Line 596: FROM fnd_resp_functions rf, fnd_form_functions ff

592: -- End fix bug #4930424-remove TABLE ACCESS FULL
593:
594: CURSOR c_funct(p_responsibility_id NUMBER, p_function_name VARCHAR2) IS
595: SELECT rf.action_id, ff.function_id
596: FROM fnd_resp_functions rf, fnd_form_functions ff
597: WHERE rf.responsibility_id(+) = p_responsibility_id
598: AND ff.function_name = p_function_name
599: AND rf.action_id(+) = ff.function_id
600: AND rf.rule_type(+) = 'F';

Line 604: Select function_id from fnd_form_functions

600: AND rf.rule_type(+) = 'F';
601:
602: -- Begin by Ehuh to fix a bug 4639561
603: CURSOR get_function_id IS
604: Select function_id from fnd_form_functions
605: where function_name = 'IEX_COLL_LOAN';
606:
607: CURSOR get_menu_id IS
608: Select menu_id from fnd_menus