APPS.PA_WORKFLOW_HISTORY dependencies on PA_WF_NTF_PERFORMERS

Line 54: FROM pa_wf_ntf_performers

50:
51: CURSOR get_old_seq
52: IS
53: SELECT MAX(sequence_number)
54: FROM pa_wf_ntf_performers
55: WHERE
56: wf_type_code = 'APPROVAL_FYI'
57: AND item_type = itemtype
58: AND item_key = itemkey

Line 129: INSERT INTO pa_wf_ntf_performers

125: --debug_msg_s1 ('Main: Save comment history: func ' || funcmode);
126:
127:
128:
129: INSERT INTO pa_wf_ntf_performers
130: (
131: wf_type_code,
132: item_type,
133: item_key,

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