APPS.IEX_CHECKLIST_UTILITY dependencies on FND_MENUS

Line 386: FROM fnd_responsibility resp, fnd_menus menu

382: p_leasing_enabled IN VARCHAR2,
383: x_return_status OUT NOCOPY VARCHAR2) IS
384: CURSOR c_resp IS
385: SELECT resp.application_id, resp.responsibility_id, resp.menu_id
386: FROM fnd_responsibility resp, fnd_menus menu
387: WHERE resp.menu_id = menu.menu_id
388: AND menu.menu_name = 'IEX_COLLECTIONS_AGENT'
389: -- Begin fix bug #4930424-remove TABLE ACCESS FULL
390: AND resp.application_id = 695;

Line 555: FROM fnd_responsibility resp, fnd_menus menu

551: p_loan_enabled IN VARCHAR2,
552: x_return_status OUT NOCOPY VARCHAR2) IS
553: CURSOR c_resp IS
554: SELECT resp.application_id, resp.responsibility_id, resp.menu_id
555: FROM fnd_responsibility resp, fnd_menus menu
556: WHERE resp.menu_id = menu.menu_id
557: AND menu.menu_name = 'IEX_COLLECTIONS_AGENT'
558: -- Begin fix bug #4930424-remove TABLE ACCESS FULL
559: AND resp.application_id = 695;

Line 576: Select menu_id from fnd_menus

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
577: where menu_name = 'IEX_COLL';
578:
579: CURSOR get_entry_sequence(p_menu_id NUMBER, p_function_id NUMBER) IS
580: Select entry_sequence from fnd_menu_entries