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_ES_COMP_CERT_ARCHIVE_PKG dependencies on FND_DATE

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

345: FROM per_addresses addr
346: WHERE addr.person_id = p_person_id
347: AND addr.primary_flag = 'Y'
348: AND p_termination_date between addr.date_from and
349: nvl(addr.date_to,fnd_date.canonical_to_date('4712/12/31'));
350: --
351: l_addr csr_person_addr%rowtype;
352: l_found boolean;
353: l_province per_addresses.region_2%type ;

Line 470: ,fnd_date.canonical_to_date(pps.pds_information9) vacation_from

466: ,pps.pds_information5 accrued_vacation
467: ,pps.pds_information6 vacation_accrued
468: ,pps.pds_information7 vacation_taken
469: ,pps.pds_information8 vacation_reamining
470: ,fnd_date.canonical_to_date(pps.pds_information9) vacation_from
471: ,fnd_date.canonical_to_date(pps.pds_information10) vacation_to
472: FROM per_all_people_f pap
473: ,per_all_assignments_f paa
474: ,per_periods_of_service pps

Line 471: ,fnd_date.canonical_to_date(pps.pds_information10) vacation_to

467: ,pps.pds_information6 vacation_accrued
468: ,pps.pds_information7 vacation_taken
469: ,pps.pds_information8 vacation_reamining
470: ,fnd_date.canonical_to_date(pps.pds_information9) vacation_from
471: ,fnd_date.canonical_to_date(pps.pds_information10) vacation_to
472: FROM per_all_people_f pap
473: ,per_all_assignments_f paa
474: ,per_periods_of_service pps
475: ,pay_assignment_actions paas

Line 518: ,fnd_date.canonical_to_date(pps.pds_information9) vacation_from

514: ,pps.pds_information5 accrued_vacation
515: ,pps.pds_information6 vacation_accrued
516: ,pps.pds_information7 vacation_taken
517: ,pps.pds_information8 vacation_reamining
518: ,fnd_date.canonical_to_date(pps.pds_information9) vacation_from
519: ,fnd_date.canonical_to_date(pps.pds_information10) vacation_to
520: FROM per_all_people_f pap
521: ,per_all_assignments_f paa
522: ,pay_assignment_actions paas

Line 519: ,fnd_date.canonical_to_date(pps.pds_information10) vacation_to

515: ,pps.pds_information6 vacation_accrued
516: ,pps.pds_information7 vacation_taken
517: ,pps.pds_information8 vacation_reamining
518: ,fnd_date.canonical_to_date(pps.pds_information9) vacation_from
519: ,fnd_date.canonical_to_date(pps.pds_information10) vacation_to
520: FROM per_all_people_f pap
521: ,per_all_assignments_f paa
522: ,pay_assignment_actions paas
523: ,pay_payroll_actions ppa

Line 706: , p_action_information9 => fnd_date.date_to_displaydate(l_employee_data.start_date)

702: , p_action_information5 => l_emp_ss_id.ss_id
703: , p_action_information6 => l_employee_data.cont_group
704: , p_action_information7 => l_employee_data.prof_catg
705: , p_action_information8 => l_emp_occupation
706: , p_action_information9 => fnd_date.date_to_displaydate(l_employee_data.start_date)
707: , p_action_information10 => fnd_date.date_to_displaydate(l_employee_data.end_date)
708: , p_action_information11 => fnd_date.date_to_displaydate(l_contract_data.contract_end_date)
709: , p_action_information12 => l_leaving_reason
710: , p_action_information13 => l_employee_data.accrued_vacation

Line 707: , p_action_information10 => fnd_date.date_to_displaydate(l_employee_data.end_date)

703: , p_action_information6 => l_employee_data.cont_group
704: , p_action_information7 => l_employee_data.prof_catg
705: , p_action_information8 => l_emp_occupation
706: , p_action_information9 => fnd_date.date_to_displaydate(l_employee_data.start_date)
707: , p_action_information10 => fnd_date.date_to_displaydate(l_employee_data.end_date)
708: , p_action_information11 => fnd_date.date_to_displaydate(l_contract_data.contract_end_date)
709: , p_action_information12 => l_leaving_reason
710: , p_action_information13 => l_employee_data.accrued_vacation
711: , p_action_information14 => l_vac_days

Line 708: , p_action_information11 => fnd_date.date_to_displaydate(l_contract_data.contract_end_date)

704: , p_action_information7 => l_employee_data.prof_catg
705: , p_action_information8 => l_emp_occupation
706: , p_action_information9 => fnd_date.date_to_displaydate(l_employee_data.start_date)
707: , p_action_information10 => fnd_date.date_to_displaydate(l_employee_data.end_date)
708: , p_action_information11 => fnd_date.date_to_displaydate(l_contract_data.contract_end_date)
709: , p_action_information12 => l_leaving_reason
710: , p_action_information13 => l_employee_data.accrued_vacation
711: , p_action_information14 => l_vac_days
712: , p_action_information15 => fnd_date.date_to_displaydate(l_employee_data.vacation_from)

Line 712: , p_action_information15 => fnd_date.date_to_displaydate(l_employee_data.vacation_from)

708: , p_action_information11 => fnd_date.date_to_displaydate(l_contract_data.contract_end_date)
709: , p_action_information12 => l_leaving_reason
710: , p_action_information13 => l_employee_data.accrued_vacation
711: , p_action_information14 => l_vac_days
712: , p_action_information15 => fnd_date.date_to_displaydate(l_employee_data.vacation_from)
713: , p_action_information16 => fnd_date.date_to_displaydate(l_employee_data.vacation_to)
714: , p_action_information17 => fnd_date.date_to_displaydate(l_sickness_start_date)
715: , p_action_information20 => l_contract_data.contract_type
716: , p_action_information21 => l_employee_data.type

Line 713: , p_action_information16 => fnd_date.date_to_displaydate(l_employee_data.vacation_to)

709: , p_action_information12 => l_leaving_reason
710: , p_action_information13 => l_employee_data.accrued_vacation
711: , p_action_information14 => l_vac_days
712: , p_action_information15 => fnd_date.date_to_displaydate(l_employee_data.vacation_from)
713: , p_action_information16 => fnd_date.date_to_displaydate(l_employee_data.vacation_to)
714: , p_action_information17 => fnd_date.date_to_displaydate(l_sickness_start_date)
715: , p_action_information20 => l_contract_data.contract_type
716: , p_action_information21 => l_employee_data.type
717: , p_action_information22 => l_employee_data.abs_attn_id

Line 714: , p_action_information17 => fnd_date.date_to_displaydate(l_sickness_start_date)

710: , p_action_information13 => l_employee_data.accrued_vacation
711: , p_action_information14 => l_vac_days
712: , p_action_information15 => fnd_date.date_to_displaydate(l_employee_data.vacation_from)
713: , p_action_information16 => fnd_date.date_to_displaydate(l_employee_data.vacation_to)
714: , p_action_information17 => fnd_date.date_to_displaydate(l_sickness_start_date)
715: , p_action_information20 => l_contract_data.contract_type
716: , p_action_information21 => l_employee_data.type
717: , p_action_information22 => l_employee_data.abs_attn_id
718: , p_action_information23 => l_wc_prov);

Line 783: , p_action_information12 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_cont_base.last_td_date))

779: , p_action_information8 => l_cont_base.contribution_days
780: , p_action_information9 => l_cont_base.RS_cont_base
781: , p_action_information10 => l_cont_base.IA_ID_Contribution
782: , p_action_information11 => l_cont_base.note
783: , p_action_information12 => fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_cont_base.last_td_date))
784: );
785:
786: END LOOP;
787: