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.HR_EX_EMPLOYEE_API dependencies on PER_PERSON_TYPES

Line 664: l_system_person_type per_person_types.system_person_type%TYPE;

660: l_person_type_id per_all_people_f.person_type_id%TYPE;
661: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
662: l_proc varchar2(72)
663: := g_package || 'actual_termination_emp';
664: l_system_person_type per_person_types.system_person_type%TYPE;
665: l_system_person_type1 per_person_types.system_person_type%TYPE;
666: l_per_effective_start_date per_people_f.effective_start_date%TYPE;
667: l_datetrack_mode varchar2(30);
668: l_validation_start_date date;

Line 665: l_system_person_type1 per_person_types.system_person_type%TYPE;

661: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
662: l_proc varchar2(72)
663: := g_package || 'actual_termination_emp';
664: l_system_person_type per_person_types.system_person_type%TYPE;
665: l_system_person_type1 per_person_types.system_person_type%TYPE;
666: l_per_effective_start_date per_people_f.effective_start_date%TYPE;
667: l_datetrack_mode varchar2(30);
668: l_validation_start_date date;
669: l_validation_end_date date;

Line 697: from per_person_type_usages_f ptu, per_person_types ppt

693: l_start_date date;
694:
695: cursor fpt_future_ptu_changes is
696: select null
697: from per_person_type_usages_f ptu, per_person_types ppt
698: where ptu.person_id = l_person_id
699: and ptu.effective_start_date > l_actual_termination_date
700: and ppt.person_type_id = ptu.person_type_id
701: and ppt.system_person_type in ('EMP','CWK');

Line 706: from per_all_people_f per, per_person_types ppt

702:
703: cursor fut_person_rec is
704: select per.person_type_id, per.object_version_number, per.effective_start_date
705: ,per.applicant_number, per.employee_number, per.npw_number
706: from per_all_people_f per, per_person_types ppt
707: where per.person_id = l_person_id
708: and per.effective_start_date > l_actual_termination_date + 1
709: and per.person_type_id = ppt.person_type_id
710: and ppt.system_person_type in ('EMP','EMP_APL');

Line 746: , per_person_types pet

742: , pds.last_standard_process_date
743: from per_all_people_f per
744: , per_business_groups bus
745: , per_periods_of_service pds
746: , per_person_types pet
747: where pds.period_of_service_id = p_period_of_service_id
748: and bus.business_group_id = pds.business_group_id
749: and per.person_id = pds.person_id
750: and l_actual_termination_date between per.effective_start_date

Line 2216: , per_person_types pet

2212: cursor csr_valid_ex_emp is
2213: select null
2214: from per_all_people_f per
2215: , per_person_type_usages_f ptu
2216: , per_person_types pet
2217: where per.person_id = l_person_id
2218: and l_exemppet_eff_date between per.effective_start_date
2219: and per.effective_end_date
2220: and per.person_id = ptu.person_id