APPS.PAY_KR_NPA_PKG dependencies on FND_DATE

Line 95: SELECT to_date('01-11-'||to_char(to_number(to_char(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters)),'YYYY'))-1),'DD-MM-YYYY')

91: l_locking_action_id NUMBER;
92: l_start_date DATE;
93: l_end_date DATE;
94: CURSOR csr_date IS
95: SELECT to_date('01-11-'||to_char(to_number(to_char(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters)),'YYYY'))-1),'DD-MM-YYYY')
96: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters))
97: FROM pay_payroll_actions bppa
98: WHERE bppa.payroll_action_id = p_payroll_action_id;
99:

Line 96: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters))

92: l_start_date DATE;
93: l_end_date DATE;
94: CURSOR csr_date IS
95: SELECT to_date('01-11-'||to_char(to_number(to_char(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters)),'YYYY'))-1),'DD-MM-YYYY')
96: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters))
97: FROM pay_payroll_actions bppa
98: WHERE bppa.payroll_action_id = p_payroll_action_id;
99:
100: ------------------------------------------------------------------------------

Line 324: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);

320: pay_archive.g_context_values.value(4) := to_char(l_assignment_id);
321: pay_archive.g_context_values.name(5) := 'ASSIGNMENT_ACTION_ID';
322: pay_archive.g_context_values.value(5) := to_char(p_assignment_action_id);
323: pay_archive.g_context_values.name(6) := 'DATE_EARNED';
324: pay_archive.g_context_values.value(6) := fnd_date.date_to_canonical(g_pact.effective_date);
325: pay_archive.g_context_values.name(7) := 'TAX_UNIT_ID';
326: pay_archive.g_context_values.value(7) := to_char(l_est_id); -- Bug 3506172
327: pay_archive.g_context_values.sz := 7;
328: