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_JP_ITAX_REPORT_PKG dependencies on FND_DATE

Line 246: , fnd_date.canonical_to_date(PERSON.JP_DATE_START) HIRE_DATE

242: , OTHER.DISASTERED D48
243: , OTHER.FOREIGNER D49
244: , OTHER.EMPLOYED D50
245: , OTHER.UNEMPLOYED D51
246: , fnd_date.canonical_to_date(PERSON.JP_DATE_START) HIRE_DATE
247: , fnd_date.canonical_to_date(PERSON.ACTUAL_TERMINATION_DATE) ACTUAL_TERMINATION_DATE
248: /* bug.6208573. ACTION_INFORMATION21/22/23 obsolete.
249: , to_number(PERSON.EMPLOYMENT_DATE_YEAR) D52
250: , to_number(PERSON.EMPLOYMENT_DATE_MONTH) D53

Line 247: , fnd_date.canonical_to_date(PERSON.ACTUAL_TERMINATION_DATE) ACTUAL_TERMINATION_DATE

243: , OTHER.FOREIGNER D49
244: , OTHER.EMPLOYED D50
245: , OTHER.UNEMPLOYED D51
246: , fnd_date.canonical_to_date(PERSON.JP_DATE_START) HIRE_DATE
247: , fnd_date.canonical_to_date(PERSON.ACTUAL_TERMINATION_DATE) ACTUAL_TERMINATION_DATE
248: /* bug.6208573. ACTION_INFORMATION21/22/23 obsolete.
249: , to_number(PERSON.EMPLOYMENT_DATE_YEAR) D52
250: , to_number(PERSON.EMPLOYMENT_DATE_MONTH) D53
251: , to_number(PERSON.EMPLOYMENT_DATE_DAY) D54

Line 319: 'fnd_date.canonical_to_date(person.actual_termination_date)

315: elsif p_include_terminated_flag = 'Y' then
316: if p_termination_date_from is not null then
317: if p_termination_date_to is not null then
318: append_where_clause(
319: 'fnd_date.canonical_to_date(person.actual_termination_date)
320: between fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_from) || ''')
321: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_to) || ''')');
322: else
323: append_where_clause(

Line 320: between fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_from) || ''')

316: if p_termination_date_from is not null then
317: if p_termination_date_to is not null then
318: append_where_clause(
319: 'fnd_date.canonical_to_date(person.actual_termination_date)
320: between fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_from) || ''')
321: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_to) || ''')');
322: else
323: append_where_clause(
324: 'fnd_date.canonical_to_date(person.actual_termination_date) >= fnd_date.canonical_to_date(''' ||

Line 321: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_to) || ''')');

317: if p_termination_date_to is not null then
318: append_where_clause(
319: 'fnd_date.canonical_to_date(person.actual_termination_date)
320: between fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_from) || ''')
321: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_to) || ''')');
322: else
323: append_where_clause(
324: 'fnd_date.canonical_to_date(person.actual_termination_date) >= fnd_date.canonical_to_date(''' ||
325: fnd_date.date_to_canonical(p_termination_date_from) || ''')');

Line 324: 'fnd_date.canonical_to_date(person.actual_termination_date) >= fnd_date.canonical_to_date(''' ||

320: between fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_from) || ''')
321: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_to) || ''')');
322: else
323: append_where_clause(
324: 'fnd_date.canonical_to_date(person.actual_termination_date) >= fnd_date.canonical_to_date(''' ||
325: fnd_date.date_to_canonical(p_termination_date_from) || ''')');
326: end if;
327: else
328: if p_termination_date_to is not null then

Line 325: fnd_date.date_to_canonical(p_termination_date_from) || ''')');

321: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_to) || ''')');
322: else
323: append_where_clause(
324: 'fnd_date.canonical_to_date(person.actual_termination_date) >= fnd_date.canonical_to_date(''' ||
325: fnd_date.date_to_canonical(p_termination_date_from) || ''')');
326: end if;
327: else
328: if p_termination_date_to is not null then
329: append_where_clause(

Line 330: 'fnd_date.canonical_to_date(person.actual_termination_date) <= fnd_date.canonical_to_date(''' ||

326: end if;
327: else
328: if p_termination_date_to is not null then
329: append_where_clause(
330: 'fnd_date.canonical_to_date(person.actual_termination_date) <= fnd_date.canonical_to_date(''' ||
331: fnd_date.date_to_canonical(p_termination_date_to) || ''')');
332: end if;
333: end if;
334: end if;

Line 331: fnd_date.date_to_canonical(p_termination_date_to) || ''')');

327: else
328: if p_termination_date_to is not null then
329: append_where_clause(
330: 'fnd_date.canonical_to_date(person.actual_termination_date) <= fnd_date.canonical_to_date(''' ||
331: fnd_date.date_to_canonical(p_termination_date_to) || ''')');
332: end if;
333: end if;
334: end if;
335: --

Line 484: append_item(p_tag, fnd_date.date_to_canonical(p_value));

480: p_value in date)
481: is
482: begin
483: if p_value is not null then
484: append_item(p_tag, fnd_date.date_to_canonical(p_value));
485: end if;
486: end append_item;
487: begin
488: if g_index is not null then