392: ,group_id, external_doc_ref
393: -- Bug 4065112 ends
394:
395: from ap_invoices_interface h,
396: ap_interface_rejections r,
397: ap_lookup_codes lc
398: where h.request_id = c_request_id
399: and nvl(r.notify_vendor_flag, 'N') = 'Y'
400: and h.invoice_id = r.parent_id
450: ,group_id, external_doc_ref
451: -- Bug 4065112 ends
452: from ap_invoices_interface h,
453: ap_invoice_lines_interface l,
454: ap_interface_rejections r,
455: ap_lookup_codes lc
456: where h.request_id = c_request_id
457: and h.invoice_id = l.invoice_id
458: and nvl(r.notify_vendor_flag, 'N') = 'Y'