APPS.PAY_KW_ANNUAL_REPORTS dependencies on FND_DATE

Line 1428: fnd_date.canonical_to_date(per_information11)

1424: decode(l_format,'L',PER_INFORMATION6,SUBSTR(last_name,1,60)),
1425: decode(l_format,'L',PER_INFORMATION4,per_information1),
1426: decode(l_format,'L',PER_INFORMATION5,per_information2),
1427: sex,date_of_birth, pos.date_start , national_identifier , per_information9,per_information10,
1428: fnd_date.canonical_to_date(per_information11)
1429: FROM per_people_f ppf , per_periods_of_service pos
1430: WHERE ppf.person_id = p_person_id
1431: AND ppf.person_id = pos.person_id
1432: AND l_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 1437: SELECT hsck.segment2,job_id , fnd_date.canonical_to_date(hsck.segment3)

1433: AND trunc(l_effective_date,'MM') between trunc(pos.date_start,'MM') and nvl(pos.actual_termination_date,to_date('31-12-4712','DD-MM-YYYY'));
1434:
1435: /* Cursor for fetching the person's assignment data */
1436: CURSOR csr_p_asg_data (l_person_id number,l_date date) IS
1437: SELECT hsck.segment2,job_id , fnd_date.canonical_to_date(hsck.segment3)
1438: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck
1439: WHERE paf.person_id = l_person_id
1440: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1441: AND hsck.segment1 = p_employer_id

Line 1504: pee.entry_information4 debt,fnd_date.canonical_to_date(pee.entry_information5) start_d

1500:
1501: /* Cursor for fetching all deduction details UNION additional SI */
1502: CURSOR csr_get_ded_details (l_assignment_id number , l_assignment_action_id number, l_effective_date date) IS
1503: SELECT rrv.RESULT_VALUE val,pee.entry_information1 ref,pee.entry_information2 authority,pee.entry_information3 type,
1504: pee.entry_information4 debt,fnd_date.canonical_to_date(pee.entry_information5) start_d
1505: ,fnd_date.canonical_to_date(pee.entry_information6) end_d ,pet.element_type_id
1506: FROM pay_element_types_f pet,
1507: pay_element_entries_f pee,
1508: pay_run_results prr,

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

1501: /* Cursor for fetching all deduction details UNION additional SI */
1502: CURSOR csr_get_ded_details (l_assignment_id number , l_assignment_action_id number, l_effective_date date) IS
1503: SELECT rrv.RESULT_VALUE val,pee.entry_information1 ref,pee.entry_information2 authority,pee.entry_information3 type,
1504: pee.entry_information4 debt,fnd_date.canonical_to_date(pee.entry_information5) start_d
1505: ,fnd_date.canonical_to_date(pee.entry_information6) end_d ,pet.element_type_id
1506: FROM pay_element_types_f pet,
1507: pay_element_entries_f pee,
1508: pay_run_results prr,
1509: pay_run_result_values rrv,