DBA Data[Home] [Help]

APPS.ARP_CMREQ_WF dependencies on WF_USERS

Line 158: FROM wf_users

154: l_internal_comment VARCHAR2(1760) DEFAULT NULL;
155:
156: cursor c1 is
157: SELECT name, display_name
158: FROM wf_users
159: WHERE orig_system = 'PER'
160: AND orig_system_id = l_requestor_id;
161:
162:

Line 165: FROM wf_users

161:
162:
163: cursor c2 is
164: SELECT name, display_name
165: FROM wf_users
166: WHERE orig_system = 'FND_USR'
167: AND orig_system_id = l_requestor_id;
168:
169:

Line 2034: from wf_users wu, fnd_user fu

2030:
2031:
2032: select wu.name, wu.display_name
2033: into p_user_name, p_display_name
2034: from wf_users wu, fnd_user fu
2035: where wu.orig_system = 'PER'
2036: and wu.orig_system_id = l_employee_id
2037: and wu.orig_system_id = fu.employee_id
2038: and fu.user_id = p_user_id

Line 3139: FROM wf_users

3135: l_approver_user_name := wf_engine.context_text;
3136:
3137: SELECT orig_system_id, display_name
3138: INTO l_approver_id, l_approver_display_name
3139: FROM wf_users
3140: WHERE orig_system = 'PER'
3141: AND name = l_approver_user_name;
3142:
3143: WF_ENGINE.SetItemAttrText(p_item_type,