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 251: , fnd_date.canonical_to_date(PERSON.JP_DATE_START) HIRE_DATE

247: , OTHER.DISASTERED D48
248: , OTHER.FOREIGNER D49
249: , OTHER.EMPLOYED D50
250: , OTHER.UNEMPLOYED D51
251: , fnd_date.canonical_to_date(PERSON.JP_DATE_START) HIRE_DATE
252: , fnd_date.canonical_to_date(PERSON.ACTUAL_TERMINATION_DATE) ACTUAL_TERMINATION_DATE
253: /* bug.6208573. ACTION_INFORMATION21/22/23 obsolete.
254: , to_number(PERSON.EMPLOYMENT_DATE_YEAR) D52
255: , to_number(PERSON.EMPLOYMENT_DATE_MONTH) D53

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

248: , OTHER.FOREIGNER D49
249: , OTHER.EMPLOYED D50
250: , OTHER.UNEMPLOYED D51
251: , fnd_date.canonical_to_date(PERSON.JP_DATE_START) HIRE_DATE
252: , fnd_date.canonical_to_date(PERSON.ACTUAL_TERMINATION_DATE) ACTUAL_TERMINATION_DATE
253: /* bug.6208573. ACTION_INFORMATION21/22/23 obsolete.
254: , to_number(PERSON.EMPLOYMENT_DATE_YEAR) D52
255: , to_number(PERSON.EMPLOYMENT_DATE_MONTH) D53
256: , to_number(PERSON.EMPLOYMENT_DATE_DAY) D54

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

327: elsif p_include_terminated_flag = 'Y' then
328: if p_termination_date_from is not null then
329: if p_termination_date_to is not null then
330: append_where_clause(
331: 'fnd_date.canonical_to_date(person.actual_termination_date)
332: between fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_from) || ''')
333: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_to) || ''')');
334: else
335: append_where_clause(

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

328: if p_termination_date_from is not null then
329: if p_termination_date_to is not null then
330: append_where_clause(
331: 'fnd_date.canonical_to_date(person.actual_termination_date)
332: between fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_from) || ''')
333: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_to) || ''')');
334: else
335: append_where_clause(
336: 'fnd_date.canonical_to_date(person.actual_termination_date) >= fnd_date.canonical_to_date(''' ||

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

329: if p_termination_date_to is not null then
330: append_where_clause(
331: 'fnd_date.canonical_to_date(person.actual_termination_date)
332: between fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_from) || ''')
333: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_to) || ''')');
334: else
335: append_where_clause(
336: 'fnd_date.canonical_to_date(person.actual_termination_date) >= fnd_date.canonical_to_date(''' ||
337: fnd_date.date_to_canonical(p_termination_date_from) || ''')');

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

332: between fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_from) || ''')
333: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_to) || ''')');
334: else
335: append_where_clause(
336: 'fnd_date.canonical_to_date(person.actual_termination_date) >= fnd_date.canonical_to_date(''' ||
337: fnd_date.date_to_canonical(p_termination_date_from) || ''')');
338: end if;
339: else
340: if p_termination_date_to is not null then

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

333: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(p_termination_date_to) || ''')');
334: else
335: append_where_clause(
336: 'fnd_date.canonical_to_date(person.actual_termination_date) >= fnd_date.canonical_to_date(''' ||
337: fnd_date.date_to_canonical(p_termination_date_from) || ''')');
338: end if;
339: else
340: if p_termination_date_to is not null then
341: append_where_clause(

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

338: end if;
339: else
340: if p_termination_date_to is not null then
341: append_where_clause(
342: 'fnd_date.canonical_to_date(person.actual_termination_date) <= fnd_date.canonical_to_date(''' ||
343: fnd_date.date_to_canonical(p_termination_date_to) || ''')');
344: end if;
345: end if;
346: end if;

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

339: else
340: if p_termination_date_to is not null then
341: append_where_clause(
342: 'fnd_date.canonical_to_date(person.actual_termination_date) <= fnd_date.canonical_to_date(''' ||
343: fnd_date.date_to_canonical(p_termination_date_to) || ''')');
344: end if;
345: end if;
346: end if;
347: --

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

496: p_value in date)
497: is
498: begin
499: if p_value is not null then
500: append_item(p_tag, fnd_date.date_to_canonical(p_value));
501: end if;
502: end append_item;
503: begin
504: if g_index is not null then