DBA Data[Home] [Help]

APPS.ENG_VAL_TO_ID dependencies on MFG_LOOKUPS

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;