APPS.PO_CHANGEORDERWF_PVT dependencies on WF_USER_ROLES

Line 6054: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;

6050: x_resultout -> Variable to set the role in the Workflow file
6051: t_document_type -> Temporary Variable used to store the document type
6052: */
6053:
6054: l_role_name WF_USER_ROLES.ROLE_NAME%TYPE;
6055: l_role_display_name varchar2(100):=null;
6056: l_expiration_date DATE;
6057: l_vendor_id NUMBER;
6058: x_resultout varchar2(100):=null;

Line 8027: from wf_user_roles wur,wf_users wr

8023: end if;
8024:
8025: select wur.user_name
8026: into l_user_name
8027: from wf_user_roles wur,wf_users wr
8028: where wur.role_name=p_ntf_role_name and
8029: wr.name =wur.user_name and
8030: upper(wr.email_address)=upper(l_email);
8031: