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

Line 77: l_person_id per_all_people_f.person_id%TYPE;

73: ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
74: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
75: ) IS
76:
77: l_person_id per_all_people_f.person_id%TYPE;
78: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
79: l_employee_number per_all_people_f.employee_number%TYPE;
80: l_effective_start_date date;
81: l_effective_end_date date;

Line 78: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

74: ,p_rehire_reason in varchar2 default hr_api.g_varchar2
75: ) IS
76:
77: l_person_id per_all_people_f.person_id%TYPE;
78: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
79: l_employee_number per_all_people_f.employee_number%TYPE;
80: l_effective_start_date date;
81: l_effective_end_date date;
82: l_full_name per_all_people_f.full_name%TYPE;

Line 79: l_employee_number per_all_people_f.employee_number%TYPE;

75: ) IS
76:
77: l_person_id per_all_people_f.person_id%TYPE;
78: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
79: l_employee_number per_all_people_f.employee_number%TYPE;
80: l_effective_start_date date;
81: l_effective_end_date date;
82: l_full_name per_all_people_f.full_name%TYPE;
83: l_comment_id per_all_people_f.comment_id%TYPE;

Line 82: l_full_name per_all_people_f.full_name%TYPE;

78: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
79: l_employee_number per_all_people_f.employee_number%TYPE;
80: l_effective_start_date date;
81: l_effective_end_date date;
82: l_full_name per_all_people_f.full_name%TYPE;
83: l_comment_id per_all_people_f.comment_id%TYPE;
84: l_name_combination_warning boolean;
85: l_assign_payroll_warning boolean;
86: l_orig_hire_warning boolean;

Line 83: l_comment_id per_all_people_f.comment_id%TYPE;

79: l_employee_number per_all_people_f.employee_number%TYPE;
80: l_effective_start_date date;
81: l_effective_end_date date;
82: l_full_name per_all_people_f.full_name%TYPE;
83: l_comment_id per_all_people_f.comment_id%TYPE;
84: l_name_combination_warning boolean;
85: l_assign_payroll_warning boolean;
86: l_orig_hire_warning boolean;
87: l_proc varchar2(100) := g_package ||'update_per_details';

Line 95: from per_all_people_f per

91: cursor csr_get_derived_details is
92: select per.person_id
93: , per.employee_number
94: , per.object_version_number
95: from per_all_people_f per
96: , per_business_groups bus
97: , per_periods_of_service pds
98: , per_person_types pet
99: where pds.period_of_service_id = p_period_of_service_id

Line 228: FROM per_all_people_f ppf -- Bug 2130066 fix

224: -- of maximum hierarchy level specified in the Supervisor Security profile.
225: ----------------------------------------------------------------------------
226: CURSOR csr_get_subordinate IS
227: SELECT ppf.person_id
228: FROM per_all_people_f ppf -- Bug 2130066 fix
229: ,per_all_assignments_f paf
230: ,per_periods_of_service ppos
231: WHERE paf.supervisor_id = l_number_value
232: AND paf.person_id = ppf.person_id

Line 246: FROM per_all_people_f ppf -- Bug 2130066 fix

242: and nvl(ppos.actual_termination_date
243: ,l_effective_date)
244: UNION -- CWK Phase III Changes.
245: SELECT ppf.person_id
246: FROM per_all_people_f ppf -- Bug 2130066 fix
247: ,per_all_assignments_f paf
248: ,per_periods_of_placement ppop
249: WHERE paf.supervisor_id = l_number_value
250: AND paf.person_id = ppf.person_id

Line 1714: ln_person_id per_all_people_f.person_id%TYPE;

1710: ld_actual_term_date
1711: per_periods_of_service.actual_termination_date%TYPE;
1712: lv_term_reason per_periods_of_service.leaving_reason%TYPE;
1713: ll_term_comments per_periods_of_service.comments%TYPE;
1714: ln_person_id per_all_people_f.person_id%TYPE;
1715: ln_period_of_service_id
1716: per_periods_of_service.period_of_service_id%TYPE;
1717: ln_object_version_number
1718: per_periods_of_service.object_version_number%TYPE;

Line 1755: lv_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;

1751:
1752: lv_person_type_id per_person_types.person_type_id%TYPE;
1753: lv_assignment_status_type_id
1754: per_assignment_status_types.assignment_status_type_id%TYPE;
1755: lv_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
1756: lv_rehire_reason per_all_people_f.rehire_reason%TYPE;
1757:
1758: l_proc varchar2(100) := g_package ||'process_api';
1759:

Line 1756: lv_rehire_reason per_all_people_f.rehire_reason%TYPE;

1752: lv_person_type_id per_person_types.person_type_id%TYPE;
1753: lv_assignment_status_type_id
1754: per_assignment_status_types.assignment_status_type_id%TYPE;
1755: lv_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
1756: lv_rehire_reason per_all_people_f.rehire_reason%TYPE;
1757:
1758: l_proc varchar2(100) := g_package ||'process_api';
1759:
1760: -- Added for FR localization bug 2881583