DBA Data[Home] [Help]

APPS.IEX_CHECKLIST_UTILITY dependencies on FND_RESPONSIBILITY

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 742: FROM fnd_responsibility resp

738: p_collections_methods IN VARCHAR2,
739: x_return_status OUT NOCOPY VARCHAR2) IS
740: CURSOR c_resp IS
741: SELECT resp.application_id, resp.responsibility_id, resp.menu_id, resp.responsibility_key
742: FROM fnd_responsibility resp
743: WHERE resp.application_id = 695;
744: l_return BOOLEAN;
745: l_promise_enabled VARCHAR2(1);
746: l_strategy_enabled VARCHAR2(1);