DBA Data[Home] [Help]

APPS.PA_WORKFLOW_HISTORY dependencies on WF_USERS

Line 184: FROM pa_wf_ntf_performers pw, wf_users wu, pa_lookups pl

180: wu.display_name user_full_name,
181: pl.meaning action_code,
182: pw.action_date,
183: pw.approver_comments
184: FROM pa_wf_ntf_performers pw, wf_users wu, pa_lookups pl
185: WHERE --pw.wf_type_code = 'APPROVAL_FYI'
186: pw.item_type = l_item_type -- 'PAWFPPRA'
187: AND pw.item_key = l_item_key --32715
188: AND pw.object_id2 = l_object_id --10020

Line 200: FROM pa_wf_ntf_performers pw, wf_users wu

196: wu.display_name user_full_name,
197: pw.action_code,
198: pw.action_date,
199: pw.approver_comments
200: FROM pa_wf_ntf_performers pw, wf_users wu
201: WHERE --pw.wf_type_code = 'APPROVAL_FYI'
202: pw.item_type = l_item_type
203: AND pw.item_key = l_item_key
204: AND pw.object_id2 = l_object_id

Line 326: FROM pa_wf_ntf_performers pw, wf_users wu, pa_lookups pl

322: wu.display_name user_full_name,
323: pl.meaning action_code,
324: pw.action_date,
325: pw.approver_comments
326: FROM pa_wf_ntf_performers pw, wf_users wu, pa_lookups pl
327: WHERE --pw.wf_type_code = 'APPROVAL_FYI'
328: pw.item_type = l_item_type -- 'PAWFPPRA'
329: AND pw.item_key = l_item_key --32715
330: AND pw.object_id2 = l_object_id --10020

Line 344: wf_users wu,pa_lookups pl

340: ias.end_date action_date,
341: wu.display_name user_full_name
342: from wf_item_activity_statuses ias,
343: wf_process_activities pa,
344: wf_users wu,pa_lookups pl
345: where ias.item_type = l_item_type
346: and ias.item_key = l_item_key
347: and pa.instance_label = 'CI_APPROVAL_REQUEST'
348: and ias.process_activity = pa.instance_id