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 458: NVL(fnd_date.canonical_to_date(peev1.screen_entry_value), pee.effective_start_date) start_date,

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 577: fnd_date.canonical_to_date(AEI_INFORMATION1) start_date,

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

Line 578: fnd_date.canonical_to_date(AEI_INFORMATION2) end_date,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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