DBA Data[Home] [Help]

APPS.IEX_CHECKLIST_UTILITY dependencies on FND_RESPONSIBILITY

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

706: p_collections_methods IN VARCHAR2,
707: x_return_status OUT NOCOPY VARCHAR2) IS
708: CURSOR c_resp IS
709: SELECT resp.application_id, resp.responsibility_id, resp.menu_id, resp.responsibility_key
710: FROM fnd_responsibility resp
711: WHERE resp.application_id = 695;
712: l_return BOOLEAN;
713: l_promise_enabled VARCHAR2(1);
714: l_strategy_enabled VARCHAR2(1);