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 235: FROM per_all_people_f ppf -- Bug 2130066 fix

231: -- of maximum hierarchy level specified in the Supervisor Security profile.
232: ----------------------------------------------------------------------------
233: CURSOR csr_get_subordinate IS
234: SELECT ppf.person_id
235: FROM per_all_people_f ppf -- Bug 2130066 fix
236: ,per_all_assignments_f paf
237: ,per_periods_of_service ppos
238: WHERE paf.supervisor_id = l_number_value
239: AND paf.person_id = ppf.person_id

Line 255: FROM per_all_people_f ppf -- Bug 2130066 fix

251: and ((dummy = 'N' and paf.supervisor_assignment_id=l_asg_number_value)
252: OR dummy = 'Y')
253: UNION -- CWK Phase III Changes.
254: SELECT ppf.person_id
255: FROM per_all_people_f ppf -- Bug 2130066 fix
256: ,per_all_assignments_f paf
257: ,per_periods_of_placement ppop
258: WHERE paf.supervisor_id = l_number_value
259: AND paf.person_id = ppf.person_id

Line 1838: ln_person_id per_all_people_f.person_id%TYPE;

1834: ld_actual_term_date
1835: per_periods_of_service.actual_termination_date%TYPE;
1836: lv_term_reason per_periods_of_service.leaving_reason%TYPE;
1837: ll_term_comments per_periods_of_service.comments%TYPE;
1838: ln_person_id per_all_people_f.person_id%TYPE;
1839: ln_period_of_service_id
1840: per_periods_of_service.period_of_service_id%TYPE;
1841: ln_object_version_number
1842: per_periods_of_service.object_version_number%TYPE;

Line 1879: lv_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;

1875:
1876: lv_person_type_id per_person_types.person_type_id%TYPE;
1877: lv_assignment_status_type_id
1878: per_assignment_status_types.assignment_status_type_id%TYPE;
1879: lv_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
1880: lv_rehire_reason per_all_people_f.rehire_reason%TYPE;
1881:
1882: l_proc varchar2(100) := g_package ||'process_api';
1883:

Line 1880: lv_rehire_reason per_all_people_f.rehire_reason%TYPE;

1876: lv_person_type_id per_person_types.person_type_id%TYPE;
1877: lv_assignment_status_type_id
1878: per_assignment_status_types.assignment_status_type_id%TYPE;
1879: lv_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
1880: lv_rehire_reason per_all_people_f.rehire_reason%TYPE;
1881:
1882: l_proc varchar2(100) := g_package ||'process_api';
1883:
1884: -- Added for FR localization bug 2881583

Line 3120: FROM per_all_people_f ppf, -- Changed to use base table, see bug 2130066

3116: paf2.assignment_number SUPERVISOR_ASSIGNMENT_NUMBER,
3117: jbs2.name SUPERVISOR_JOB_NAME,
3118: pos2.name SUPERVISOR_POSITION_NAME,
3119: org2.name SUPERVISOR_ORGANIZATION
3120: FROM per_all_people_f ppf, -- Changed to use base table, see bug 2130066
3121: per_all_people_f ppf2 ,
3122: per_all_assignments_f paf ,
3123: per_all_assignments_f paf2 ,
3124: per_jobs_vl jbs ,

Line 3121: per_all_people_f ppf2 ,

3117: jbs2.name SUPERVISOR_JOB_NAME,
3118: pos2.name SUPERVISOR_POSITION_NAME,
3119: org2.name SUPERVISOR_ORGANIZATION
3120: FROM per_all_people_f ppf, -- Changed to use base table, see bug 2130066
3121: per_all_people_f ppf2 ,
3122: per_all_assignments_f paf ,
3123: per_all_assignments_f paf2 ,
3124: per_jobs_vl jbs ,
3125: hr_all_positions_f_tl pos ,