DBA Data[Home] [Help]

APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on FND_DATE

Line 257: ,fnd_date.date_to_canonical(ppa.date_earned) date_earned

253: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv1.input_value_id) hire_date
254: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) leaving_date
255: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv3.input_value_id) prev_hire_date
256: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv4.input_value_id) prev_leaving_date
257: ,fnd_date.date_to_canonical(ppa.date_earned) date_earned
258: ,ft.territory_code country_code
259: from pay_run_results prr1,
260: pay_run_results prr2,
261: pay_payroll_actions ppa,

Line 1018: pay_archive.g_context_values.value(cnt) := fnd_date.date_to_canonical(l_date_earned);

1014: --
1015: if l_date_earned is not null then
1016: cnt := cnt + 1;
1017: pay_archive.g_context_values.name(cnt) := 'DATE_EARNED';
1018: pay_archive.g_context_values.value(cnt) := fnd_date.date_to_canonical(l_date_earned);
1019: end if;
1020: --
1021: if l_tax_unit_id is not null then
1022: cnt := cnt + 1;