APPS.ENG_VAL_TO_ID dependencies on MFG_LOOKUPS

Line 642: SELECT to_number(lookup_code) into l_result from mfg_lookups

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