752:
753: -- Get the status using the lookup type.
754: SELECT meaning
755: INTO l_status
756: FROM oe_lookups
757: WHERE lookup_type = l_lookup_type
758: AND lookup_code = p_status_code;
759: ELSE
760: -- If the document type code is PA_BLANKET or PA_CONTRACT