APPS.PAY_GB_P11D_MAGTAPE dependencies on HR_LOOKUPS

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

Line 320: from hr_lookups hlu

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
323: and hlu.ENABLED_FLAG = 'Y'
324: and fnd_date.canonical_to_date(l_effective_date) between