DBA Data[Home] [Help]

APPS.POS_SUPPLIER_USER_REG_PKG dependencies on FND_FORM_FUNCTIONS

Line 624: FROM fnd_menu_entries fme, (SELECT function_id FROM fnd_form_functions WHERE function_name = 'POS_REG_APPROVE_EXT_USERS') func

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
625: START WITH fme.function_id = func.function_id
626: CONNECT BY PRIOR menu_id = sub_menu_id
627: )
628: AND fr.application_id = 177

Line 685: FROM fnd_form_functions

681: --step 1: find the users that can approve external user registrations
682:
683: SELECT function_id
684: INTO l_approver_func_id
685: FROM fnd_form_functions
686: WHERE function_name = 'POS_REG_APPROVE_EXT_USERS';
687:
688: OPEN x_refcur FOR
689: 'SELECT DISTINCT fu.user_name