eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on FND_DATE

Line 72: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters,'START_DATE')) start_date

68: CURSOR csr_parameter_info
69: (p_payroll_action_id NUMBER) IS
70: SELECT
71: TO_NUMBER ( GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER') ) Legal
72: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters,'START_DATE')) start_date
73: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters,'END_DATE')) end_date
74: ,GET_PARAMETER(legislative_parameters,'ARCHIVE') ARCHIVE_OR_NOT
75: ,business_group_id BG_ID
76: ,effective_date

Line 73: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters,'END_DATE')) end_date

69: (p_payroll_action_id NUMBER) IS
70: SELECT
71: TO_NUMBER ( GET_PARAMETER(legislative_parameters,'LEGAL_EMPLOYER') ) Legal
72: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters,'START_DATE')) start_date
73: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters,'END_DATE')) end_date
74: ,GET_PARAMETER(legislative_parameters,'ARCHIVE') ARCHIVE_OR_NOT
75: ,business_group_id BG_ID
76: ,effective_date
77: FROM pay_payroll_actions

Line 116: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters, 'DATE')) report_date

112: (p_payroll_action_id IN NUMBER) IS
113: SELECT business_group_id
114: ,legislative_parameters
115: ,get_parameter(legislative_parameters, 'LEGAL_EMPLOYER_ID') legal_employer_id
116: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters, 'DATE')) report_date
117: FROM pay_payroll_actions
118: WHERE payroll_action_id = p_payroll_action_id;
119: --
120: l_parameter_rec csr_parameters%ROWTYPE;

Line 243: p_action_information5=> fnd_date.date_to_canonical(g_effective_date),

239: p_action_information1=> 'PYSESTOA',
240: p_action_information2=> to_char(g_business_group_id),
241: p_action_information3=> to_char(g_legal_employer_id),
242: p_action_information4=> l_legal_employer_details_rec.name,
243: p_action_information5=> fnd_date.date_to_canonical(g_effective_date),
244: p_action_information6=> fnd_date.date_to_canonical(g_start_date),
245: p_action_information7=> fnd_date.date_to_canonical(g_end_date),
246: p_action_information8=> NULL,
247: p_action_information9=> NULL,

Line 244: p_action_information6=> fnd_date.date_to_canonical(g_start_date),

240: p_action_information2=> to_char(g_business_group_id),
241: p_action_information3=> to_char(g_legal_employer_id),
242: p_action_information4=> l_legal_employer_details_rec.name,
243: p_action_information5=> fnd_date.date_to_canonical(g_effective_date),
244: p_action_information6=> fnd_date.date_to_canonical(g_start_date),
245: p_action_information7=> fnd_date.date_to_canonical(g_end_date),
246: p_action_information8=> NULL,
247: p_action_information9=> NULL,
248: p_action_information10=> NULL,

Line 245: p_action_information7=> fnd_date.date_to_canonical(g_end_date),

241: p_action_information3=> to_char(g_legal_employer_id),
242: p_action_information4=> l_legal_employer_details_rec.name,
243: p_action_information5=> fnd_date.date_to_canonical(g_effective_date),
244: p_action_information6=> fnd_date.date_to_canonical(g_start_date),
245: p_action_information7=> fnd_date.date_to_canonical(g_end_date),
246: p_action_information8=> NULL,
247: p_action_information9=> NULL,
248: p_action_information10=> NULL,
249: p_action_information11=> NULL,

Line 459: NVL(fnd_date.canonical_to_date(peev1.screen_entry_value), pee.effective_start_date) start_date,

455: p_report_end_date DATE,
456: p_start_date_iv NUMBER,
457: p_end_date_iv NUMBER) IS
458: SELECT pee.element_entry_id,
459: NVL(fnd_date.canonical_to_date(peev1.screen_entry_value), pee.effective_start_date) start_date,
460: NVL(fnd_date.canonical_to_date(peev2.screen_entry_value), pee.effective_end_date) end_date
461: FROM pay_element_entries_f pee ,
462: pay_element_entry_values_f peev1,
463: pay_element_entry_values_f peev2

Line 460: NVL(fnd_date.canonical_to_date(peev2.screen_entry_value), pee.effective_end_date) end_date

456: p_start_date_iv NUMBER,
457: p_end_date_iv NUMBER) IS
458: SELECT pee.element_entry_id,
459: NVL(fnd_date.canonical_to_date(peev1.screen_entry_value), pee.effective_start_date) start_date,
460: NVL(fnd_date.canonical_to_date(peev2.screen_entry_value), pee.effective_end_date) end_date
461: FROM pay_element_entries_f pee ,
462: pay_element_entry_values_f peev1,
463: pay_element_entry_values_f peev2
464: WHERE

Line 488: fnd_date.canonical_to_date(prrv1.result_value) start_date,

484: p_full_day_iv NUMBER,
485: p_end_date_iv NUMBER,
486: p_part_day_iv NUMBER) IS
487: SELECT prr.source_id,
488: fnd_date.canonical_to_date(prrv1.result_value) start_date,
489: prrv2.result_value full_day,
490: fnd_date.canonical_to_date(prrv3.result_value) end_date,
491: prrv4.result_value part_day
492: FROM pay_assignment_actions paa,

Line 490: fnd_date.canonical_to_date(prrv3.result_value) end_date,

486: p_part_day_iv NUMBER) IS
487: SELECT prr.source_id,
488: fnd_date.canonical_to_date(prrv1.result_value) start_date,
489: prrv2.result_value full_day,
490: fnd_date.canonical_to_date(prrv3.result_value) end_date,
491: prrv4.result_value part_day
492: FROM pay_assignment_actions paa,
493: pay_payroll_actions ppa,
494: pay_run_results prr,

Line 549: SELECT fnd_date.canonical_to_date(prrv1.result_value) start_date,

545: p_start_date_iv NUMBER,
546: p_14th_date_iv NUMBER,
547: p_end_date_iv NUMBER,
548: p_emp_days_iv NUMBER) IS
549: SELECT fnd_date.canonical_to_date(prrv1.result_value) start_date,
550: fnd_date.canonical_to_date(prrv2.result_value) fourteenth_date,
551: fnd_date.canonical_to_date(prrv3.result_value) end_date,
552: prrv4.result_value employer_days
553: FROM pay_assignment_actions paa,

Line 550: fnd_date.canonical_to_date(prrv2.result_value) fourteenth_date,

546: p_14th_date_iv NUMBER,
547: p_end_date_iv NUMBER,
548: p_emp_days_iv NUMBER) IS
549: SELECT fnd_date.canonical_to_date(prrv1.result_value) start_date,
550: fnd_date.canonical_to_date(prrv2.result_value) fourteenth_date,
551: fnd_date.canonical_to_date(prrv3.result_value) end_date,
552: prrv4.result_value employer_days
553: FROM pay_assignment_actions paa,
554: pay_payroll_actions ppa,

Line 551: fnd_date.canonical_to_date(prrv3.result_value) end_date,

547: p_end_date_iv NUMBER,
548: p_emp_days_iv NUMBER) IS
549: SELECT fnd_date.canonical_to_date(prrv1.result_value) start_date,
550: fnd_date.canonical_to_date(prrv2.result_value) fourteenth_date,
551: fnd_date.canonical_to_date(prrv3.result_value) end_date,
552: prrv4.result_value employer_days
553: FROM pay_assignment_actions paa,
554: pay_payroll_actions ppa,
555: pay_run_results prr,

Line 578: fnd_date.canonical_to_date(AEI_INFORMATION1) start_date,

574:
575: CURSOR csr_correction_data
576: (p_assignment_id NUMBER) IS
577: SELECT assignment_extra_info_id,
578: fnd_date.canonical_to_date(AEI_INFORMATION1) start_date,
579: fnd_date.canonical_to_date(AEI_INFORMATION2) end_date,
580: AEI_INFORMATION3 full_day,
581: AEI_INFORMATION4 part_day
582: FROM PER_ASSIGNMENT_EXTRA_INFO

Line 579: fnd_date.canonical_to_date(AEI_INFORMATION2) end_date,

575: CURSOR csr_correction_data
576: (p_assignment_id NUMBER) IS
577: SELECT assignment_extra_info_id,
578: fnd_date.canonical_to_date(AEI_INFORMATION1) start_date,
579: fnd_date.canonical_to_date(AEI_INFORMATION2) end_date,
580: AEI_INFORMATION3 full_day,
581: AEI_INFORMATION4 part_day
582: FROM PER_ASSIGNMENT_EXTRA_INFO
583: WHERE assignment_id=p_assignment_id

Line 760: IF l_check_end_date <> fnd_date.date_to_canonical(l_sickness_end_date) THEN

756: If more than one results exist for the same entry
757: */
758:
759:
760: IF l_check_end_date <> fnd_date.date_to_canonical(l_sickness_end_date) THEN
761: OPEN csr_total_sickness_days(l_sickness_element_type_rec.element_type_id
762: ,l_assignments_rec.assignment_id
763: ,g_start_date
764: ,g_end_date

Line 771: set action_information8 = fnd_date.date_to_canonical(greatest(l_sickness_end_date,fnd_date.canonical_to_date(l_check_end_date))),

767: FETCH csr_total_sickness_days INTO l_total_sickness_days_rec;
768: CLOSE csr_total_sickness_days;
769:
770: UPDATE pay_action_information
771: set action_information8 = fnd_date.date_to_canonical(greatest(l_sickness_end_date,fnd_date.canonical_to_date(l_check_end_date))),
772: action_information10 = least(l_total_sickness_days_rec.full_day,l_employer_days)
773: WHERE action_context_id = l_assact_id
774: AND action_information13 = l_start_end_date.source_id;
775: l_total_full_day:= nvl(least(l_total_sickness_days_rec.full_day,l_employer_days),0) + nvl(l_total_full_day,0)

Line 870: p_action_information7=> fnd_date.date_to_canonical(l_sickness_start_date ),

866: p_action_information3=> g_legal_employer_id,
867: p_action_information4=> l_assignments_rec.national_identifier,
868: p_action_information5=> l_assignments_rec.full_name,
869: p_action_information6=> l_assignments_rec.employee_number,
870: p_action_information7=> fnd_date.date_to_canonical(l_sickness_start_date ),
871: p_action_information8=> fnd_date.date_to_canonical(l_sickness_end_date),
872: p_action_information9=> to_char(l_assignments_rec.person_id),
873: p_action_information10=> l_full_day,
874: p_action_information11=> l_part_day, -- part day balance to be added

Line 871: p_action_information8=> fnd_date.date_to_canonical(l_sickness_end_date),

867: p_action_information4=> l_assignments_rec.national_identifier,
868: p_action_information5=> l_assignments_rec.full_name,
869: p_action_information6=> l_assignments_rec.employee_number,
870: p_action_information7=> fnd_date.date_to_canonical(l_sickness_start_date ),
871: p_action_information8=> fnd_date.date_to_canonical(l_sickness_end_date),
872: p_action_information9=> to_char(l_assignments_rec.person_id),
873: p_action_information10=> l_full_day,
874: p_action_information11=> l_part_day, -- part day balance to be added
875: p_action_information12=> NULL, -- correction

Line 921: p_action_information7=> fnd_date.date_to_canonical(l_csr_correction_data.start_date),

917: p_action_information3=> g_legal_employer_id,
918: p_action_information4=> l_assignments_rec.national_identifier,
919: p_action_information5=> l_assignments_rec.full_name,
920: p_action_information6=> l_assignments_rec.employee_number,
921: p_action_information7=> fnd_date.date_to_canonical(l_csr_correction_data.start_date),
922: p_action_information8=> fnd_date.date_to_canonical(l_csr_correction_data.end_date),
923: p_action_information9=> to_char(l_assignments_rec.person_id),
924: p_action_information10=> l_csr_correction_data.full_day,
925: p_action_information11=> l_csr_correction_data.part_day,

Line 922: p_action_information8=> fnd_date.date_to_canonical(l_csr_correction_data.end_date),

918: p_action_information4=> l_assignments_rec.national_identifier,
919: p_action_information5=> l_assignments_rec.full_name,
920: p_action_information6=> l_assignments_rec.employee_number,
921: p_action_information7=> fnd_date.date_to_canonical(l_csr_correction_data.start_date),
922: p_action_information8=> fnd_date.date_to_canonical(l_csr_correction_data.end_date),
923: p_action_information9=> to_char(l_assignments_rec.person_id),
924: p_action_information10=> l_csr_correction_data.full_day,
925: p_action_information11=> l_csr_correction_data.part_day,
926: p_action_information12=> '1',

Line 1132: fnd_date.canonical_to_date(pai.action_information7) start_date,

1128: IS
1129: SELECT
1130: pai.action_information4 national_identifier,
1131: pai.action_information5 full_name,
1132: fnd_date.canonical_to_date(pai.action_information7) start_date,
1133: fnd_date.canonical_to_date(pai.action_information8) end_date,
1134: pai.action_information10 full_day,
1135: pai.action_information11 part_day,
1136: pai.action_information12 correction

Line 1133: fnd_date.canonical_to_date(pai.action_information8) end_date,

1129: SELECT
1130: pai.action_information4 national_identifier,
1131: pai.action_information5 full_name,
1132: fnd_date.canonical_to_date(pai.action_information7) start_date,
1133: fnd_date.canonical_to_date(pai.action_information8) end_date,
1134: pai.action_information10 full_day,
1135: pai.action_information11 part_day,
1136: pai.action_information12 correction
1137: FROM