APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on FND_DATE

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

248: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv1.input_value_id) hire_date
249: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv2.input_value_id) leaving_date
250: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv3.input_value_id) prev_hire_date
251: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv4.input_value_id) prev_leaving_date
252: ,fnd_date.date_to_canonical(ppa.date_earned) date_earned
253: ,decode(substr(pap.national_identifier,8,1),1,NULL,2,NULL,3,NULL,4,NULL,pap.country_of_birth) country_code
254: from pay_run_results prr1,
255: pay_run_results prr2,
256: pay_payroll_actions ppa,

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

911: --
912: if l_date_earned is not null then
913: cnt := cnt + 1;
914: pay_archive.g_context_values.name(cnt) := 'DATE_EARNED';
915: pay_archive.g_context_values.value(cnt) := fnd_date.date_to_canonical(l_date_earned);
916: end if;
917: --
918: if l_tax_unit_id is not null then
919: cnt := cnt + 1;