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: