210: ai.reference_key2,
211: ai.reference_key3,
212: ai.reference_key4,
213: ai.reference_key5
214: FROM ap_invoices_all ai, ap_invoice_payments_all aip
215: WHERE ai.invoice_id = aip.invoice_id
216: AND aip.check_id = pn_check_id;
217:
218: lv_return_code VARCHAR2(1);
359: ai.reference_key2,
360: ai.reference_key3,
361: ai.reference_key4,
362: ai.reference_key5
363: FROM ap_invoices_all ai, ap_invoice_payments_all aip
364: WHERE ai.invoice_id = aip.invoice_id
365: AND aip.check_id = pn_check_id;
366:
367: ln_applicaton_id ap_invoices_all.application_id%TYPE;