APPS.PO_CHANGEORDERWF_PVT dependencies on WF_USER_ROLES

Line 6212: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;

6208: x_resultout -> Variable to set the role in the Workflow file
6209: t_document_type -> Temporary Variable used to store the document type
6210: */
6211:
6212: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;
6213: l_role_display_name varchar2(100):=null;
6214: l_expiration_date DATE;
6215: l_vendor_id NUMBER;
6216: x_resultout varchar2(100):=null;

Line 8302: from wf_user_roles wur,wf_users wr

8298: end if;
8299:
8300: select wur.user_name
8301: into l_user_name
8302: from wf_user_roles wur,wf_users wr
8303: where wur.role_name=p_ntf_role_name and
8304: wr.name =wur.user_name and
8305: upper(wr.email_address)=upper(l_email);
8306: