DBA Data[Home] [Help]

APPS.UMX_ACCESS_ROLES_PVT dependencies on WF_LOCAL_USER_ROLES

Line 218: reason wf_local_user_roles.ASSIGNMENT_REASON%type;

214: p_expiration_date in date
215: )IS
216:
217:
218: reason wf_local_user_roles.ASSIGNMENT_REASON%type;
219: begin
220:
221:
222:

Line 223: select ASSIGNMENT_REASON into reason from wf_local_user_roles

219: begin
220:
221:
222:
223: select ASSIGNMENT_REASON into reason from wf_local_user_roles
224: where USER_NAME = p_user_name
225: and ROLE_NAME = p_role_name ;
226:
227: