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 859: l_home_first_name per_all_people_f.last_name%type; -- 8605683

855: ,p_already_applicant_warning out nocopy boolean
856: ) is
857: --
858: -- Declare cursors and local variables
859: l_home_first_name per_all_people_f.last_name%type; -- 8605683
860: --
861: l_proc varchar2(72) := g_package||'initiate_deployment';
862: l_object_version_number hr_person_deployments.object_version_number%type;
863: --

Line 865: l_host_employee_number per_all_people_f.employee_number%type;

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

Line 866: l_host_applicant_number per_all_people_f.applicant_number%type;

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

Line 867: l_home_last_name per_all_people_f.last_name%type;

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

Line 868: l_home_sex per_all_people_f.sex%type;

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

Line 869: l_home_party_id per_all_people_f.party_id%type;

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

Line 870: l_home_original_date_of_hire per_all_people_f.original_date_of_hire%type;

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

Line 882: l_host_per_full_name per_all_people_f.full_name%type;

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

Line 910: l_host_contact_full_name per_all_people_f.full_name%type;

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

Line 996: from per_all_people_f papf

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

Line 1003: from per_all_people_f papf

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

Line 1050: from per_all_people_f papf

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