APPS.IEX_CHECKLIST_UTILITY dependencies on FND_MENUS

Line 418: FROM fnd_responsibility resp, fnd_menus menu

414: p_leasing_enabled IN VARCHAR2,
415: x_return_status OUT NOCOPY VARCHAR2) IS
416: CURSOR c_resp IS
417: SELECT resp.application_id, resp.responsibility_id, resp.menu_id
418: FROM fnd_responsibility resp, fnd_menus menu
419: WHERE resp.menu_id = menu.menu_id
420: AND menu.menu_name = 'IEX_COLLECTIONS_AGENT'
421: -- Begin fix bug #4930424-remove TABLE ACCESS FULL
422: AND resp.application_id = 695;

Line 587: FROM fnd_responsibility resp, fnd_menus menu

583: p_loan_enabled IN VARCHAR2,
584: x_return_status OUT NOCOPY VARCHAR2) IS
585: CURSOR c_resp IS
586: SELECT resp.application_id, resp.responsibility_id, resp.menu_id
587: FROM fnd_responsibility resp, fnd_menus menu
588: WHERE resp.menu_id = menu.menu_id
589: AND menu.menu_name = 'IEX_COLLECTIONS_AGENT'
590: -- Begin fix bug #4930424-remove TABLE ACCESS FULL
591: AND resp.application_id = 695;

Line 608: Select menu_id from fnd_menus

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
609: where menu_name = 'IEX_COLL';
610:
611: CURSOR get_entry_sequence(p_menu_id NUMBER, p_function_id NUMBER) IS
612: Select entry_sequence from fnd_menu_entries