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

Line 559: ,p_parent_table => 'PER_ALL_PEOPLE_F'

555: ,p_date_to => null
556: ,p_phone_type => 'W1'
557: ,p_phone_number => p_work_telephone
558: ,p_parent_id => l_person_id
559: ,p_parent_table => 'PER_ALL_PEOPLE_F'
560: ,p_validate => FALSE
561: ,p_effective_date => l_start_date
562: ,p_object_version_number => l_phn_object_version_number --out
563: ,p_phone_id => l_phone_id --out

Line 725: FROM per_all_people_f

721: --
722: begin
723: SELECT object_version_number
724: INTO p_per_object_Version_number
725: FROM per_all_people_f
726: WHERE person_id = l_person_id
727: And effective_start_Date = l_per_effective_start_date
728: and effective_end_Date = l_per_effective_end_date;
729: exception

Line 840: l_full_name per_all_people_f.full_name%TYPE;

836: l_comment_id number;
837: l_current_applicant_flag varchar2(1);
838: l_current_emp_or_apl_flag varchar2(1);
839: l_current_employee_flag varchar2(1);
840: l_full_name per_all_people_f.full_name%TYPE;
841: l_name_combination_warning boolean;
842: l_dob_null_warning boolean;
843: l_orig_hire_warning boolean;
844: l_pdp_object_version_number number;

Line 861: FROM per_all_people_f ppf

857: ,ppt.system_person_type
858: ,ppf.npw_number
859: ,ppf.applicant_number
860: ,ppf.employee_number
861: FROM per_all_people_f ppf
862: ,per_person_types ppt
863: WHERE ppt.person_type_id = ppf.person_type_id
864: AND ppf.person_id = p_person_id
865: AND p_effective_date between ppf.effective_start_date and ppf.effective_end_date;

Line 1210: l_full_name per_all_people_f.full_name%TYPE;

1206: l_comment_id number;
1207: l_current_applicant_flag varchar2(1);
1208: l_current_emp_or_apl_flag varchar2(1);
1209: l_current_employee_flag varchar2(1);
1210: l_full_name per_all_people_f.full_name%TYPE;
1211: l_name_combination_warning boolean;
1212: l_dob_null_warning boolean;
1213: l_orig_hire_warning boolean;
1214: l_per_effective_start_date date;

Line 1236: FROM per_all_people_f ppf

1232: ,ppt.system_person_type
1233: ,ppf.npw_number
1234: ,ppf.applicant_number
1235: ,ppf.employee_number
1236: FROM per_all_people_f ppf
1237: ,per_person_types ppt
1238: WHERE ppt.person_type_id = ppf.person_type_id
1239: AND ppf.person_id = p_person_id
1240: AND p_effective_date between ppf.effective_start_date and ppf.effective_end_date;

Line 1716: l_full_name per_all_people_f.full_name%TYPE;

1712: l_effective_end_date date;
1713: l_effective_start_date date;
1714: l_npw_number per_people_f.npw_number%TYPE;
1715: l_exists varchar2(1);
1716: l_full_name per_all_people_f.full_name%TYPE;
1717: l_legislation_code per_business_groups.legislation_code%TYPE;
1718: l_max_tpe_end_date date;
1719: l_name_combination_warning boolean;
1720: l_orig_hire_warning boolean;

Line 1740: l_applicant_number per_all_people_f.applicant_number%TYPE;

1736: l_current_dod date;
1737: l_date_of_death date;
1738: l_ptu_object_version_number number;
1739: l_person_type_usage_id number;
1740: l_applicant_number per_all_people_f.applicant_number%TYPE;
1741: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;
1742: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
1743: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
1744: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;

Line 1741: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;

1737: l_date_of_death date;
1738: l_ptu_object_version_number number;
1739: l_person_type_usage_id number;
1740: l_applicant_number per_all_people_f.applicant_number%TYPE;
1741: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;
1742: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
1743: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
1744: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
1745: --

Line 1742: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;

1738: l_ptu_object_version_number number;
1739: l_person_type_usage_id number;
1740: l_applicant_number per_all_people_f.applicant_number%TYPE;
1741: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;
1742: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
1743: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
1744: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
1745: --
1746:

Line 1743: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;

1739: l_person_type_usage_id number;
1740: l_applicant_number per_all_people_f.applicant_number%TYPE;
1741: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;
1742: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
1743: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
1744: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
1745: --
1746:
1747: cursor csr_future_per_changes is

Line 1744: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;

1740: l_applicant_number per_all_people_f.applicant_number%TYPE;
1741: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;
1742: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
1743: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
1744: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
1745: --
1746:
1747: cursor csr_future_per_changes is
1748: select null

Line 1749: from per_all_people_f per

1745: --
1746:
1747: cursor csr_future_per_changes is
1748: select null
1749: from per_all_people_f per
1750: where per.person_id = l_person_id
1751: and per.effective_start_date > l_actual_termination_date;
1752: --
1753: cursor csr_get_asgs_to_terminate is

Line 1771: from per_all_people_f per

1767: , per.effective_start_date
1768: , per.object_version_number
1769: , per.npw_number
1770: , per.applicant_number
1771: from per_all_people_f per
1772: , per_business_groups bus
1773: , per_periods_of_placement pdp
1774: where pdp.person_id = p_person_id
1775: and pdp.date_start = p_date_start

Line 1796: from per_all_people_f

1792: and tpe.end_date;
1793: --
1794: cursor csr_date_of_death is
1795: select date_of_death
1796: from per_all_people_f
1797: where person_id = l_person_id;
1798: --
1799: --
1800: begin