DBA Data[Home] [Help]

APPS.PAY_GB_P11D_MAGTAPE dependencies on FND_LOOKUP_VALUES

Line 305: l_description fnd_lookup_values.DESCRIPTION%type;

301: l_effective_date varchar2
302: )
303: return varchar2
304: is
305: l_description fnd_lookup_values.DESCRIPTION%type;
306: begin
307: /* select upper(description) into l_description
308: from fnd_lookup_values flv
309: where flv.lookup_type = l_lookup_type

Line 308: from fnd_lookup_values flv

304: is
305: l_description fnd_lookup_values.DESCRIPTION%type;
306: begin
307: /* select upper(description) into l_description
308: from fnd_lookup_values flv
309: where flv.lookup_type = l_lookup_type
310: and flv.lookup_code = l_lookup_code
311: and flv.ENABLED_FLAG = 'Y'
312: and fnd_date.canonical_to_date(l_effective_date) between

Line 318: /*Fetching from hr_lookups instead of fnd_lookup_values*/

314: fnd_date.canonical_to_date(l_effective_date)) and
315: nvl(flv.END_DATE_ACTIVE,
316: fnd_date.canonical_to_date(l_effective_date));*/
317: /*Bug No. 3237648*/
318: /*Fetching from hr_lookups instead of fnd_lookup_values*/
319: select upper(description) into l_description
320: from hr_lookups hlu
321: where hlu.lookup_type = l_lookup_type
322: and hlu.lookup_code = l_lookup_code