APPS.PAY_KW_PIFSS_REPORT dependencies on FND_DATE

Line 216: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_temp_effective_date));

212: l_change_count := 0;
213: j := 1;
214: l_n_c := 0 ;
215: pay_balance_pkg.set_context('TAX_UNIT_ID',p_employer);
216: pay_balance_pkg.set_context('DATE_EARNED',FND_DATE.DATE_TO_CANONICAL(l_temp_effective_date));
217: l_defined_balance_id_net_asg := get_def_bal_id('SUBJECT_TO_SOCIAL_INSURANCE_ASG_RUN');
218: if csr_get_change_emp % ISOPEN then
219: close csr_get_change_emp;
220: open csr_get_change_emp(p_employer,l_temp_effective_date,p_nationality);

Line 413: SELECT rrv.RESULT_VALUE val,pee.entry_information3 type,fnd_date.canonical_to_date(pee.entry_information5) start_d

409:
410: l_ele_start_date date;
411:
412: CURSOR csr_get_ded_details (l_assignment_id number , l_assignment_action_id number, l_effective_date date) IS
413: SELECT rrv.RESULT_VALUE val,pee.entry_information3 type,fnd_date.canonical_to_date(pee.entry_information5) start_d
414: ,fnd_date.canonical_to_date(pee.entry_information6) end_d ,pet.element_type_id , pet.effective_start_date
415: FROM pay_element_types_f pet,
416: pay_element_entries_f pee,
417: pay_run_results prr,

Line 414: ,fnd_date.canonical_to_date(pee.entry_information6) end_d ,pet.element_type_id , pet.effective_start_date

410: l_ele_start_date date;
411:
412: CURSOR csr_get_ded_details (l_assignment_id number , l_assignment_action_id number, l_effective_date date) IS
413: SELECT rrv.RESULT_VALUE val,pee.entry_information3 type,fnd_date.canonical_to_date(pee.entry_information5) start_d
414: ,fnd_date.canonical_to_date(pee.entry_information6) end_d ,pet.element_type_id , pet.effective_start_date
415: FROM pay_element_types_f pet,
416: pay_element_entries_f pee,
417: pay_run_results prr,
418: pay_run_result_values rrv,