DBA Data[Home] [Help]

APPS.PQP_US_STUDENT_BEE dependencies on FND_LOOKUP_VALUES_VL

Line 43: from fnd_lookup_values_vl

39: cursor csr_lookup_meaning
40: (p_lookup_type in varchar2
41: ,p_lookup_code in varchar2)is
42: select meaning
43: from fnd_lookup_values_vl
44: where lookup_type = p_lookup_type
45: and upper(lookup_code) = upper(p_lookup_code);
46:
47: -- Cursor to get the input value id(s) for an element.

Line 163: l_lookup_meaning fnd_lookup_values_vl.meaning%type;

159: function Get_Lookup_Meaning
160: (p_lookup_type in varchar2
161: ,p_lookup_code in varchar2
162: ) return varchar2 is
163: l_lookup_meaning fnd_lookup_values_vl.meaning%type;
164: l_proc_name varchar2(150) := g_pkg ||'Get_Lookup_Meaning';
165: begin
166: hr_utility.set_location('Entering: '||l_proc_name, 5);
167: open csr_lookup_meaning