APPS.PAY_KW_ANNUAL_REPORTS dependencies on FND_DATE

Line 1370: fnd_date.canonical_to_date(per_information11)

1366: decode(l_format,'L',PER_INFORMATION6,SUBSTR(last_name,1,60)),
1367: decode(l_format,'L',PER_INFORMATION4,per_information1),
1368: decode(l_format,'L',PER_INFORMATION5,per_information2),
1369: sex,date_of_birth, pos.date_start , national_identifier , per_information9,per_information10,
1370: fnd_date.canonical_to_date(per_information11)
1371: FROM per_people_f ppf , per_periods_of_service pos
1372: WHERE ppf.person_id = p_person_id
1373: AND ppf.person_id = pos.person_id
1374: AND l_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date

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

1375: 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'));
1376:
1377: /* Cursor for fetching the person's assignment data */
1378: CURSOR csr_p_asg_data (l_person_id number,l_date date) IS
1379: SELECT hsck.segment2,job_id , fnd_date.canonical_to_date(hsck.segment3)
1380: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck
1381: WHERE paf.person_id = l_person_id
1382: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1383: AND hsck.segment1 = p_employer_id

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

1442:
1443: /* Cursor for fetching all deduction details UNION additional SI */
1444: CURSOR csr_get_ded_details (l_assignment_id number , l_assignment_action_id number, l_effective_date date) IS
1445: SELECT rrv.RESULT_VALUE val,pee.entry_information1 ref,pee.entry_information2 authority,pee.entry_information3 type,
1446: pee.entry_information4 debt,fnd_date.canonical_to_date(pee.entry_information5) start_d
1447: ,fnd_date.canonical_to_date(pee.entry_information6) end_d ,pet.element_type_id
1448: FROM pay_element_types_f pet,
1449: pay_element_entries_f pee,
1450: pay_run_results prr,

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

1443: /* Cursor for fetching all deduction details UNION additional SI */
1444: CURSOR csr_get_ded_details (l_assignment_id number , l_assignment_action_id number, l_effective_date date) IS
1445: SELECT rrv.RESULT_VALUE val,pee.entry_information1 ref,pee.entry_information2 authority,pee.entry_information3 type,
1446: pee.entry_information4 debt,fnd_date.canonical_to_date(pee.entry_information5) start_d
1447: ,fnd_date.canonical_to_date(pee.entry_information6) end_d ,pet.element_type_id
1448: FROM pay_element_types_f pet,
1449: pay_element_entries_f pee,
1450: pay_run_results prr,
1451: pay_run_result_values rrv,