31: /* Lookup po_id from p_po_code (segment1). */
32: /* Exceptions here get thrown to caller. */
33: SELECT po_header_id, type_lookup_code
34: INTO g_po_id, p_doc_type /* The value we were looking for. */
35: FROM po_headers_all
36: WHERE segment1 = p_po_code
37: AND org_id = p_org_id;
38:
39: /* Save the keys for repeated lookups. */