APPS.POS_SUPPLIER_USER_REG_PKG dependencies on FND_RESPONSIBILITY

Line 296: FROM fnd_responsibility

292: ln_resp_id NUMBER;
293: --
294: CURSOR l_resp_id_cur (p_appl_id NUMBER, p_resp_key VARCHAR2) IS
295: SELECT responsibility_id
296: FROM fnd_responsibility
297: WHERE application_id = p_appl_id
298: AND responsibility_key = p_resp_key
299: AND (end_date IS NULL OR end_date > start_date);
300: BEGIN

Line 620: fnd_responsibility fr,

616:
617: cursor l_role_cur is
618: SELECT final.role_name
619: FROM fnd_user fu,
620: fnd_responsibility fr,
621: wf_user_roles wur, wf_user_roles final
622: WHERE fr.menu_id in
623: (SELECT fme.menu_id
624: FROM fnd_menu_entries fme, (SELECT function_id FROM fnd_form_functions WHERE function_name = 'POS_REG_APPROVE_EXT_USERS') func

Line 691: fnd_responsibility fr,

687:
688: OPEN x_refcur FOR
689: 'SELECT DISTINCT fu.user_name
690: FROM fnd_user fu,
691: fnd_responsibility fr,
692: wf_user_roles wur
693: WHERE fr.menu_id in
694: (SELECT fme.menu_id
695: FROM fnd_menu_entries fme