DBA Data[Home] [Help]

APPS.MTH_UTIL_PKG dependencies on FND_LOOKUP_VALUES

Line 797: SELECT lookup_code INTO v_lookup_code FROM FND_LOOKUP_VALUES WHERE

793: Function mth_ua_get_val RETURN NUMBER IS
794: v_lookup_code varchar2(30);
795: BEGIN
796: --NULL
797: SELECT lookup_code INTO v_lookup_code FROM FND_LOOKUP_VALUES WHERE
798: lookup_type='MTH_UNASSIGNED_L' AND language=userenv('LANG');
799:
800: RETURN(to_number(v_lookup_code));
801:

Line 829: SELECT meaning INTO v_lookup_meaning FROM FND_LOOKUP_VALUES WHERE

825: Function mth_ua_get_meaning RETURN VARCHAR2 IS
826: v_lookup_meaning varchar2(80);
827: BEGIN
828: --NULL
829: SELECT meaning INTO v_lookup_meaning FROM FND_LOOKUP_VALUES WHERE
830: lookup_type='MTH_UNASSIGNED_L' AND language=userenv('LANG');
831:
832: RETURN(v_lookup_meaning);
833: