DBA Data[Home] [Help]

APPS.ETRM_FNDNAV dependencies on FND_LOOKUP_VALUES

Line 57: return fnd_lookup_values.meaning%type is

53: end get_tablename;
54:
55: function get_lookup_meaning(c_lookup_type in varchar2
56: , c_lookup_code in varchar2)
57: return fnd_lookup_values.meaning%type is
58:
59: cursor cur_lookup_values(c_lookup_type in varchar2
60: , c_lookup_code in varchar2) is
61: select t.meaning

Line 62: from fnd_lookup_values t

58:
59: cursor cur_lookup_values(c_lookup_type in varchar2
60: , c_lookup_code in varchar2) is
61: select t.meaning
62: from fnd_lookup_values t
63: , fnd_lookup_types l
64: where l.lookup_type = c_lookup_type
65: and t.lookup_code = c_lookup_code
66: and l.lookup_type = t.lookup_type

Line 71: v_return_value fnd_lookup_values.meaning%type := NULL;

67: and l.security_group_id = t.security_group_id
68: and l.view_application_id = t.view_application_id
69: and t.language = userenv('LANG');
70:
71: v_return_value fnd_lookup_values.meaning%type := NULL;
72:
73: begin
74: for l_rec in cur_lookup_values (c_lookup_type => c_lookup_type
75: , c_lookup_code => c_lookup_code) loop

Line 1424: from fnd_lookup_values t

1420: , n_appid in number) is
1421: select t.lookup_code
1422: , t.meaning
1423: , t.description
1424: from fnd_lookup_values t
1425: , fnd_lookup_types l
1426: where l.application_id = n_appid
1427: and l.lookup_type = c_lookup_type
1428: and l.lookup_type = t.lookup_type