218: BEGIN
219:
220: Select invoice_type_lookup_code
221: Into l_invoice_type_lookup_code
222: From ap_invoices_all ai
223: Where ai.invoice_id = x_invoice_id;
224:
225: EXCEPTION
226: When Others then
439: g_approval_workflow_flag,
440: g_transfer_flag,
441: g_trx_business_category,
442: g_org_id
443: FROM ap_invoices_all ai, --bug 5056051
444: ap_system_parameters asp,
445: ap_suppliers pv, --bug 5056051
446: ap_supplier_sites pvs --bug 5056051
447: WHERE ai.invoice_id = x_invoice_id