APPS.ARP_CMREQ_WF dependencies on WF_USERS

Line 160: FROM wf_users

156:
157: -- bug 7559456
158: cursor c1(emp_id number) is
159: SELECT name, display_name
160: FROM wf_users
161: WHERE orig_system = 'PER'
162: AND orig_system_id = emp_id;
163:
164:

Line 167: FROM wf_users

163:
164:
165: cursor c2(user_id number) is
166: SELECT name, display_name
167: FROM wf_users
168: WHERE orig_system = 'FND_USR'
169: AND orig_system_id = user_id;
170:
171: cursor c3(user_id1 number) is

Line 2075: from wf_users wu, fnd_user fu

2071:
2072:
2073: select wu.name, wu.display_name
2074: into p_user_name, p_display_name
2075: from wf_users wu, fnd_user fu
2076: where wu.orig_system = 'PER'
2077: and wu.orig_system_id = l_employee_id
2078: and wu.orig_system_id = fu.employee_id
2079: and fu.user_id = p_user_id

Line 3246: FROM wf_users

3242: l_approver_user_name := wf_engine.context_text;
3243:
3244: SELECT orig_system_id, display_name
3245: INTO l_approver_id, l_approver_display_name
3246: FROM wf_users
3247: WHERE orig_system = 'PER'
3248: AND name = l_approver_user_name;
3249:
3250: WF_ENGINE.SetItemAttrText(p_item_type,