289: ,ame_trans_approval_history h
290: ,fnd_lookups lookup
291: ,fnd_lookups lookup2
292: ,fnd_lookups lookup3
293: ,ame_approval_groups_vl apg
294: WHERE ol.transaction_id = h.transaction_id
295: AND ol.application_id = h.application_id
296: AND ol.name = h.name
297: AND ol.item_class = h.item_class
368: FROM ame_temp_old_approver_lists ol
369: ,fnd_lookups lookup
370: ,fnd_lookups lookup2
371: ,fnd_lookups lookup3
372: ,ame_approval_groups_vl apg
373: WHERE NOT EXISTS
374: (
375: SELECT x.transaction_id
376: ,x.application_id