APPS.PA_WORKFLOW_HISTORY dependencies on PA_WF_NTF_PERFORMERS

Line 49: FROM pa_wf_ntf_performers

45:
46: CURSOR get_old_seq
47: IS
48: SELECT MAX(sequence_number)
49: FROM pa_wf_ntf_performers
50: WHERE
51: wf_type_code = 'APPROVAL_FYI'
52: AND item_type = itemtype
53: AND item_key = itemkey

Line 124: INSERT INTO pa_wf_ntf_performers

120: --debug_msg_s1 ('Main: Save comment history: func ' || funcmode);
121:
122:
123:
124: INSERT INTO pa_wf_ntf_performers
125: (
126: wf_type_code,
127: item_type,
128: item_key,

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

174: wu.display_name user_full_name,
175: pl.meaning action_code,
176: pw.action_date,
177: pw.approver_comments
178: FROM pa_wf_ntf_performers pw, wf_users wu, pa_lookups pl
179: WHERE --pw.wf_type_code = 'APPROVAL_FYI'
180: pw.item_type = l_item_type -- 'PAWFPPRA'
181: AND pw.item_key = l_item_key --32715
182: AND pw.object_id2 = l_object_id --10020

Line 194: FROM pa_wf_ntf_performers pw, wf_users wu

190: wu.display_name user_full_name,
191: pw.action_code,
192: pw.action_date,
193: pw.approver_comments
194: FROM pa_wf_ntf_performers pw, wf_users wu
195: WHERE --pw.wf_type_code = 'APPROVAL_FYI'
196: pw.item_type = l_item_type
197: AND pw.item_key = l_item_key
198: AND pw.object_id2 = l_object_id