Line 643: SELECT to_number(lookup_code) into l_result from mfg_lookups
639: RETURN NUMBER
640: IS
641: l_result NUMBER;
642: BEGIN 643: SELECT to_number(lookup_code) into l_result from mfg_lookups 644: where lookup_type = 'ENG_ECN_APPROVAL_STATUS'
645: and meaning = p_approval_status_name;
646:
647: return l_result;