DBA Data[Home] [Help]

APPS.MSC_X_HZ_PLAN dependencies on FND_LOOKUP_VALUES

Line 3979: -- get the graph title from the fnd_lookup_values table

3975: END;
3976:
3977: if v_pref IS NOT NULL OR arg_default_pref = 1 then
3978:
3979: -- get the graph title from the fnd_lookup_values table
3980: if v_graphtype <> 0 then
3981: v_graphtitle := get_lookup_name('MSC_X_GRAPH_OPTION', v_graphtype);
3982: end if;
3983:

Line 4837: * lookup types and codes from teh fnd_lookup_values table.

4833: END;
4834:
4835: /**
4836: * The foll function retrieves the meaning for different
4837: * lookup types and codes from teh fnd_lookup_values table.
4838: */
4839: FUNCTION get_lookup_name(v_lookup_type IN VARCHAR2, v_lookup_code IN NUMBER) RETURN VARCHAR2
4840: IS
4841: v_name VARCHAR2(250) := '';

Line 4844: FROM fnd_lookup_values

4840: IS
4841: v_name VARCHAR2(250) := '';
4842: BEGIN
4843: SELECT meaning INTO v_name
4844: FROM fnd_lookup_values
4845: WHERE lookup_type = v_lookup_type
4846: AND lookup_code = nvl(v_lookup_code,-1)
4847: AND language = userenv('lang');
4848: