eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_P11D_MAGTAPE dependencies on FND_DATE

Line 129: l_token_value := fnd_date.date_to_canonical (l_benefit_start_date);

125: l_token_value := l_submitter_id;
126: end if;
127: elsif p_token_name = 'BENEFIT_START_DATE'
128: then
129: l_token_value := fnd_date.date_to_canonical (l_benefit_start_date);
130: elsif p_token_name = 'BENEFIT_END_DATE'
131: then
132: l_token_value := fnd_date.date_to_canonical (l_benefit_end_date);
133: else

Line 132: l_token_value := fnd_date.date_to_canonical (l_benefit_end_date);

128: then
129: l_token_value := fnd_date.date_to_canonical (l_benefit_start_date);
130: elsif p_token_name = 'BENEFIT_END_DATE'
131: then
132: l_token_value := fnd_date.date_to_canonical (l_benefit_end_date);
133: else
134: l_token_value := l_token_value;
135: end if;
136:

Line 312: and fnd_date.canonical_to_date(l_effective_date) between

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
313: nvl(flv.START_DATE_ACTIVE,
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));*/

Line 314: fnd_date.canonical_to_date(l_effective_date)) and

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
313: nvl(flv.START_DATE_ACTIVE,
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*/

Line 316: fnd_date.canonical_to_date(l_effective_date));*/

312: and fnd_date.canonical_to_date(l_effective_date) between
313: nvl(flv.START_DATE_ACTIVE,
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

Line 324: and fnd_date.canonical_to_date(l_effective_date) between

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
325: nvl(hlu.START_DATE_ACTIVE,
326: fnd_date.canonical_to_date(l_effective_date)) and
327: nvl(hlu.END_DATE_ACTIVE,
328: fnd_date.canonical_to_date(l_effective_date));

Line 326: fnd_date.canonical_to_date(l_effective_date)) and

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
325: nvl(hlu.START_DATE_ACTIVE,
326: fnd_date.canonical_to_date(l_effective_date)) and
327: nvl(hlu.END_DATE_ACTIVE,
328: fnd_date.canonical_to_date(l_effective_date));
329:
330: return l_description;

Line 328: fnd_date.canonical_to_date(l_effective_date));

324: and fnd_date.canonical_to_date(l_effective_date) between
325: nvl(hlu.START_DATE_ACTIVE,
326: fnd_date.canonical_to_date(l_effective_date)) and
327: nvl(hlu.END_DATE_ACTIVE,
328: fnd_date.canonical_to_date(l_effective_date));
329:
330: return l_description;
331: exception
332: when Others then