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_PERSON_DEPLOYMENT_API dependencies on PER_ALL_PEOPLE_F

Line 864: l_host_employee_number per_all_people_f.employee_number%type;

860: l_proc varchar2(72) := g_package||'initiate_deployment';
861: l_object_version_number hr_person_deployments.object_version_number%type;
862: --
863: -- Key data from per and asg
864: l_host_employee_number per_all_people_f.employee_number%type;
865: l_host_applicant_number per_all_people_f.applicant_number%type;
866: l_home_last_name per_all_people_f.last_name%type;
867: l_home_sex per_all_people_f.sex%type;
868: l_home_party_id per_all_people_f.party_id%type;

Line 865: l_host_applicant_number per_all_people_f.applicant_number%type;

861: l_object_version_number hr_person_deployments.object_version_number%type;
862: --
863: -- Key data from per and asg
864: l_host_employee_number per_all_people_f.employee_number%type;
865: l_host_applicant_number per_all_people_f.applicant_number%type;
866: l_home_last_name per_all_people_f.last_name%type;
867: l_home_sex per_all_people_f.sex%type;
868: l_home_party_id per_all_people_f.party_id%type;
869: l_home_original_date_of_hire per_all_people_f.original_date_of_hire%type;

Line 866: l_home_last_name per_all_people_f.last_name%type;

862: --
863: -- Key data from per and asg
864: l_host_employee_number per_all_people_f.employee_number%type;
865: l_host_applicant_number per_all_people_f.applicant_number%type;
866: l_home_last_name per_all_people_f.last_name%type;
867: l_home_sex per_all_people_f.sex%type;
868: l_home_party_id per_all_people_f.party_id%type;
869: l_home_original_date_of_hire per_all_people_f.original_date_of_hire%type;
870: l_host_person_id number;

Line 867: l_home_sex per_all_people_f.sex%type;

863: -- Key data from per and asg
864: l_host_employee_number per_all_people_f.employee_number%type;
865: l_host_applicant_number per_all_people_f.applicant_number%type;
866: l_home_last_name per_all_people_f.last_name%type;
867: l_home_sex per_all_people_f.sex%type;
868: l_home_party_id per_all_people_f.party_id%type;
869: l_home_original_date_of_hire per_all_people_f.original_date_of_hire%type;
870: l_host_person_id number;
871: l_host_per_ovn number;

Line 868: l_home_party_id per_all_people_f.party_id%type;

864: l_host_employee_number per_all_people_f.employee_number%type;
865: l_host_applicant_number per_all_people_f.applicant_number%type;
866: l_home_last_name per_all_people_f.last_name%type;
867: l_home_sex per_all_people_f.sex%type;
868: l_home_party_id per_all_people_f.party_id%type;
869: l_home_original_date_of_hire per_all_people_f.original_date_of_hire%type;
870: l_host_person_id number;
871: l_host_per_ovn number;
872: l_host_assignment_id number;

Line 869: l_home_original_date_of_hire per_all_people_f.original_date_of_hire%type;

865: l_host_applicant_number per_all_people_f.applicant_number%type;
866: l_home_last_name per_all_people_f.last_name%type;
867: l_home_sex per_all_people_f.sex%type;
868: l_home_party_id per_all_people_f.party_id%type;
869: l_home_original_date_of_hire per_all_people_f.original_date_of_hire%type;
870: l_host_person_id number;
871: l_host_per_ovn number;
872: l_host_assignment_id number;
873: l_host_asg_ovn number;

Line 881: l_host_per_full_name per_all_people_f.full_name%type;

877: l_host_per_esd date;
878: l_host_per_eed date;
879: l_host_asg_esd date;
880: l_host_asg_eed date;
881: l_host_per_full_name per_all_people_f.full_name%type;
882: l_home_asg_esd date;
883: l_home_asg_eed date;
884: l_host_person_extra_info_id number;
885: l_host_pei_ovn number;

Line 909: l_host_contact_full_name per_all_people_f.full_name%type;

905: l_host_ctr_ovn number;
906: l_host_contact_per_ovn number;
907: l_host_contact_per_esd date;
908: l_host_contact_per_eed date;
909: l_host_contact_full_name per_all_people_f.full_name%type;
910: l_host_contact_per_comment_id number;
911: l_pyp_element_entry_id number;
912: --
913: l_name_combination_warning boolean;

Line 994: from per_all_people_f papf

990: and pdt1.start_date <= nvl(pdt2.end_date,hr_api.g_eot));
991: --
992: cursor csr_home_per_values(p_person_id number) is
993: select papf.last_name, papf.sex, papf.party_id, papf.original_date_of_hire
994: from per_all_people_f papf
995: where papf.person_id = p_person_id
996: and l_dpl_rec.start_date between
997: papf.effective_start_date and papf.effective_end_date;
998: --

Line 1001: from per_all_people_f papf

997: papf.effective_start_date and papf.effective_end_date;
998: --
999: cursor csr_host_per_values(p_person_id number) is
1000: select papf.object_version_number
1001: from per_all_people_f papf
1002: where papf.person_id = p_person_id
1003: and l_dpl_rec.start_date between
1004: papf.effective_start_date and papf.effective_end_date;
1005: --

Line 1048: from per_all_people_f papf

1044: l_contact_rel_details csr_contact_rel_details%rowtype;
1045: --
1046: cursor csr_contact_person_details(p_person_id number, p_effective_date date) is
1047: select *
1048: from per_all_people_f papf
1049: where papf.person_id = p_person_id
1050: and p_effective_date between
1051: papf.effective_start_date and papf.effective_end_date;
1052: --