DBA Data[Home] [Help]

APPS.IEX_CHECKLIST_UTILITY dependencies on FND_FORM_FUNCTIONS

Line 395: FROM fnd_resp_functions rf, fnd_form_functions ff

391: -- End fix bug #4930424-remove TABLE ACCESS FULL
392:
393: CURSOR c_funct(p_responsibility_id NUMBER, p_function_name VARCHAR2) IS
394: SELECT rf.action_id, ff.function_id
395: FROM fnd_resp_functions rf, fnd_form_functions ff
396: WHERE rf.responsibility_id(+) = p_responsibility_id
397: AND ff.function_name = p_function_name
398: AND rf.action_id(+) = ff.function_id
399: AND rf.rule_type(+) = 'F';

Line 564: FROM fnd_resp_functions rf, fnd_form_functions ff

560: -- End fix bug #4930424-remove TABLE ACCESS FULL
561:
562: CURSOR c_funct(p_responsibility_id NUMBER, p_function_name VARCHAR2) IS
563: SELECT rf.action_id, ff.function_id
564: FROM fnd_resp_functions rf, fnd_form_functions ff
565: WHERE rf.responsibility_id(+) = p_responsibility_id
566: AND ff.function_name = p_function_name
567: AND rf.action_id(+) = ff.function_id
568: AND rf.rule_type(+) = 'F';

Line 572: Select function_id from fnd_form_functions

568: AND rf.rule_type(+) = 'F';
569:
570: -- Begin by Ehuh to fix a bug 4639561
571: CURSOR get_function_id IS
572: Select function_id from fnd_form_functions
573: where function_name = 'IEX_COLL_LOAN';
574:
575: CURSOR get_menu_id IS
576: Select menu_id from fnd_menus