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

Line 746: l_person_id per_all_people_f.person_id%TYPE;

742: -- and Rehire Reason. Hence we make following call to Person API
743: -- to update the Fields.
744:
745: DECLARE
746: l_person_id per_all_people_f.person_id%TYPE;
747: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
748: l_employee_number per_all_people_f.employee_number%TYPE;
749: l_effective_start_date date;
750: l_effective_end_date date;

Line 747: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

743: -- to update the Fields.
744:
745: DECLARE
746: l_person_id per_all_people_f.person_id%TYPE;
747: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
748: l_employee_number per_all_people_f.employee_number%TYPE;
749: l_effective_start_date date;
750: l_effective_end_date date;
751: l_full_name per_all_people_f.full_name%TYPE;

Line 748: l_employee_number per_all_people_f.employee_number%TYPE;

744:
745: DECLARE
746: l_person_id per_all_people_f.person_id%TYPE;
747: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
748: l_employee_number per_all_people_f.employee_number%TYPE;
749: l_effective_start_date date;
750: l_effective_end_date date;
751: l_full_name per_all_people_f.full_name%TYPE;
752: l_comment_id per_all_people_f.comment_id%TYPE;

Line 751: l_full_name per_all_people_f.full_name%TYPE;

747: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
748: l_employee_number per_all_people_f.employee_number%TYPE;
749: l_effective_start_date date;
750: l_effective_end_date date;
751: l_full_name per_all_people_f.full_name%TYPE;
752: l_comment_id per_all_people_f.comment_id%TYPE;
753: l_name_combination_warning boolean;
754: l_assign_payroll_warning boolean;
755: l_orig_hire_warning boolean;

Line 752: l_comment_id per_all_people_f.comment_id%TYPE;

748: l_employee_number per_all_people_f.employee_number%TYPE;
749: l_effective_start_date date;
750: l_effective_end_date date;
751: l_full_name per_all_people_f.full_name%TYPE;
752: l_comment_id per_all_people_f.comment_id%TYPE;
753: l_name_combination_warning boolean;
754: l_assign_payroll_warning boolean;
755: l_orig_hire_warning boolean;
756:

Line 761: from per_all_people_f per

757: cursor csr_get_derived_details is
758: select per.person_id
759: , per.employee_number
760: , per.object_version_number
761: from per_all_people_f per
762: where per.person_id = p_person_id
763: and p_actual_termination_date between per.effective_start_date
764: and per.effective_end_date;
765:

Line 2150: l_person_type_id per_all_people_f.person_type_id%TYPE;

2146:
2147: l_person_id per_periods_of_placement.person_id%TYPE;
2148: l_date_start per_periods_of_placement.date_start%TYPE;
2149: l_object_version_number per_periods_of_placement.object_version_number%TYPE;
2150: l_person_type_id per_all_people_f.person_type_id%TYPE;
2151: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
2152: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2153: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2154: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;

Line 2156: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;

2152: l_final_process_date per_periods_of_placement.final_process_date%TYPE;
2153: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2154: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2155: l_termination_reason per_periods_of_placement.termination_reason%TYPE;
2156: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
2157: l_rehire_reason per_all_people_f.rehire_reason%TYPE;
2158:
2159: l_proc varchar2(72) := g_package ||'process_api';
2160: l_effective_date date;

Line 2157: l_rehire_reason per_all_people_f.rehire_reason%TYPE;

2153: l_last_standard_process_date per_periods_of_placement.last_standard_process_date%TYPE;
2154: l_projected_termination_date per_periods_of_placement.projected_termination_date%TYPE;
2155: l_termination_reason per_periods_of_placement.termination_reason%TYPE;
2156: l_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
2157: l_rehire_reason per_all_people_f.rehire_reason%TYPE;
2158:
2159: l_proc varchar2(72) := g_package ||'process_api';
2160: l_effective_date date;
2161: