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.PER_HU_EMP_CERT_ARCHIVE dependencies on FND_DATE

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

44: ) IS
45: --
46: CURSOR csr_parameter_info (c_payroll_action_id NUMBER) IS
47: SELECT get_parameter(legislative_parameters, 'PAYROLL_ID')
48: ,fnd_date.canonical_to_date(get_parameter(legislative_parameters, 'DATE'))
49: ,start_date
50: ,effective_date
51: ,business_group_id
52: FROM pay_payroll_actions

Line 295: nvl(addr.date_to,fnd_date.canonical_to_date('4712/12/31'));

291: FROM per_addresses addr
292: WHERE addr.person_id = p_person_id
293: AND addr.primary_flag = 'Y'
294: AND p_termination_date between addr.date_from and
295: nvl(addr.date_to,fnd_date.canonical_to_date('4712/12/31'));
296:
297: l_addr csr_person_addr%ROWTYPE;
298: l_found BOOLEAN;
299: l_action_info_id NUMBER;

Line 350: ,fnd_date.date_to_chardate(pap.date_of_birth) date_of_birth

346: ,pap.full_name
347: ,pap.previous_last_name Maiden_name
348: ,pap.national_identifier social_security_code
349: ,pap.town_of_birth place_of_birth
350: ,fnd_date.date_to_chardate(pap.date_of_birth) date_of_birth
351: ,pap.per_information1 mother_maiden_name
352: ,fnd_date.date_to_chardate(ppf.date_start) hire_date
353: ,fnd_date.date_to_chardate(ppf.actual_termination_date) termination_date
354: ,ppf.actual_termination_date actual_termination_date

Line 352: ,fnd_date.date_to_chardate(ppf.date_start) hire_date

348: ,pap.national_identifier social_security_code
349: ,pap.town_of_birth place_of_birth
350: ,fnd_date.date_to_chardate(pap.date_of_birth) date_of_birth
351: ,pap.per_information1 mother_maiden_name
352: ,fnd_date.date_to_chardate(ppf.date_start) hire_date
353: ,fnd_date.date_to_chardate(ppf.actual_termination_date) termination_date
354: ,ppf.actual_termination_date actual_termination_date
355: ,paa.assignment_id
356: ,decode(hr.segment2,'Y','Yes','No') railway_benefit

Line 353: ,fnd_date.date_to_chardate(ppf.actual_termination_date) termination_date

349: ,pap.town_of_birth place_of_birth
350: ,fnd_date.date_to_chardate(pap.date_of_birth) date_of_birth
351: ,pap.per_information1 mother_maiden_name
352: ,fnd_date.date_to_chardate(ppf.date_start) hire_date
353: ,fnd_date.date_to_chardate(ppf.actual_termination_date) termination_date
354: ,ppf.actual_termination_date actual_termination_date
355: ,paa.assignment_id
356: ,decode(hr.segment2,'Y','Yes','No') railway_benefit
357: ,hoi.organization_id organization_id

Line 604: , p_action_information16 => fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_ppension_data.start_date),l_ele_entry_start_date))

600: , p_action_information12 => l_employee_data.hire_date
601: , p_action_information13 => l_employee_data.Termination_date
602: , p_action_information14 => l_total_sickness_holiday
603: , p_action_information15 => l_employee_data.railway_benefit
604: , p_action_information16 => fnd_date.date_to_displaydate(nvl(fnd_date.canonical_to_date(l_ppension_data.start_date),l_ele_entry_start_date))
605: , p_action_information17 => l_pension_provider_code
606: , p_action_information18 => l_ppension_data.provider_name
607: , p_action_information19 => l_ppension_data.address
608: , p_action_information20 => l_account_no

Line 614: , p_action_information26 => fnd_date.date_to_displaydate(l_issue_date)

610: , p_action_information22 => l_vpp_name(2)
611: , p_action_information23 => l_vpp_name(3)
612: , p_action_information24 => l_vpp_name(4)
613: , p_action_information25 => l_vpp_name(5)
614: , p_action_information26 => fnd_date.date_to_displaydate(l_issue_date)
615: );
616: END IF;
617: END get_employee_data;
618: