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_EMPLOYEE_API dependencies on PER_PERIODS_OF_SERVICE

Line 80: ,per_periods_of_service pds

76: FROM per_assignments_f asg1
77: ,per_assignments_f asg2
78: ,per_assignment_status_types pas1
79: ,per_assignment_status_types pas2
80: ,per_periods_of_service pds
81: WHERE pds.person_id = p_person_id
82: AND pds.person_id = asg1.person_id
83: AND pds.person_id = asg2.person_id
84: AND asg1.assignment_status_type_id = pas1.assignment_status_type_id

Line 305: l_period_of_service_id per_periods_of_service.period_of_service_id%type;

301: l_proc varchar2(72);
302: l_person_type_id per_person_types.person_type_id%type := p_person_type_id;
303: l_person_type_id1 per_person_types.person_type_id%type;
304: l_person_id per_people_f.person_id%type;
305: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
306: l_employee_number per_people_f.employee_number%type;
307: l_emp_num per_people_f.employee_number%type := p_employee_number;
308: l_applicant_number per_people_f.applicant_number%TYPE;
309: l_npw_number per_people_f.npw_number%TYPE;

Line 2858: l_period_of_service_id per_periods_of_service.period_of_service_id%type;

2854: l_applicant_number per_people_f.applicant_number%TYPE;
2855: l_npw_number per_people_f.npw_number%type;
2856: l_full_name per_people_f.full_name%type;
2857: l_object_version_number per_people_f.object_version_number%type;
2858: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
2859: l_pds_object_version_number per_periods_of_service.object_version_number%type;
2860: l_datetrack_mode varchar2(12);
2861: l_effective_date date;
2862: l_hire_date date;

Line 2859: l_pds_object_version_number per_periods_of_service.object_version_number%type;

2855: l_npw_number per_people_f.npw_number%type;
2856: l_full_name per_people_f.full_name%type;
2857: l_object_version_number per_people_f.object_version_number%type;
2858: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
2859: l_pds_object_version_number per_periods_of_service.object_version_number%type;
2860: l_datetrack_mode varchar2(12);
2861: l_effective_date date;
2862: l_hire_date date;
2863: l_assign_payroll_warning boolean :=FALSE;

Line 3021: l_final_process_date per_periods_of_service.final_process_date%type;

3017: p_employee_number out nocopy varchar2) is
3018: --
3019: l_proc varchar2(72) := g_package||'perform_validation';
3020: l_system_person_type per_person_types.system_person_type%type;
3021: l_final_process_date per_periods_of_service.final_process_date%type;
3022: l_effective_start_date per_people_f.effective_start_date%type;
3023: l_dummy_number number;
3024: l_dummy_emp_number varchar2(30);
3025: l_dummy_date date;

Line 3038: from per_periods_of_service pos

3034: pos.final_process_date
3035: --
3036: -- 115.57 (END)
3037: --
3038: from per_periods_of_service pos
3039: where pos.person_id = p_person_id
3040: order by pos.date_start desc;
3041: --
3042: -- 115.57 (START)

Line 3044: l_fpd per_periods_of_service.final_process_date%TYPE;

3040: order by pos.date_start desc;
3041: --
3042: -- 115.57 (START)
3043: --
3044: l_fpd per_periods_of_service.final_process_date%TYPE;
3045: l_atd per_periods_of_service.actual_termination_date%TYPE;
3046: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
3047: --
3048: -- Cursor to get legislation code

Line 3045: l_atd per_periods_of_service.actual_termination_date%TYPE;

3041: --
3042: -- 115.57 (START)
3043: --
3044: l_fpd per_periods_of_service.final_process_date%TYPE;
3045: l_atd per_periods_of_service.actual_termination_date%TYPE;
3046: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
3047: --
3048: -- Cursor to get legislation code
3049: --

Line 3046: l_lspd per_periods_of_service.last_standard_process_date%TYPE;

3042: -- 115.57 (START)
3043: --
3044: l_fpd per_periods_of_service.final_process_date%TYPE;
3045: l_atd per_periods_of_service.actual_termination_date%TYPE;
3046: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
3047: --
3048: -- Cursor to get legislation code
3049: --
3050: CURSOR csr_per_legislation

Line 4112: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

4108: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
4109: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
4110: l_full_name per_all_people_f.full_name%TYPE;
4111: l_name_combination_warning BOOLEAN;
4112: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
4113: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
4114: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4115: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
4116: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

Line 4113: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;

4109: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
4110: l_full_name per_all_people_f.full_name%TYPE;
4111: l_name_combination_warning BOOLEAN;
4112: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
4113: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
4114: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4115: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
4116: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4117: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

Line 4122: l_final_process_date per_periods_of_service.final_process_date%type;

4118: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
4119: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
4120: --
4121: -- Start of fix for bug 3143299
4122: l_final_process_date per_periods_of_service.final_process_date%type;
4123: --
4124: -- Local cursors
4125: cursor csr_chk_period_of_service is
4126: --

Line 4136: from per_periods_of_service pos

4132: pos.final_process_date
4133: --
4134: -- 115.57 (END)
4135: --
4136: from per_periods_of_service pos
4137: where pos.person_id = p_person_id
4138: order by pos.date_start desc;
4139: --
4140: -- 115.57 (START)

Line 4142: l_fpd per_periods_of_service.final_process_date%TYPE;

4138: order by pos.date_start desc;
4139: --
4140: -- 115.57 (START)
4141: --
4142: l_fpd per_periods_of_service.final_process_date%TYPE;
4143: l_atd per_periods_of_service.actual_termination_date%TYPE;
4144: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
4145: l_rule_value pay_legislation_rules.rule_mode%TYPE;
4146: l_rule_found BOOLEAN;

Line 4143: l_atd per_periods_of_service.actual_termination_date%TYPE;

4139: --
4140: -- 115.57 (START)
4141: --
4142: l_fpd per_periods_of_service.final_process_date%TYPE;
4143: l_atd per_periods_of_service.actual_termination_date%TYPE;
4144: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
4145: l_rule_value pay_legislation_rules.rule_mode%TYPE;
4146: l_rule_found BOOLEAN;
4147: --

Line 4144: l_lspd per_periods_of_service.last_standard_process_date%TYPE;

4140: -- 115.57 (START)
4141: --
4142: l_fpd per_periods_of_service.final_process_date%TYPE;
4143: l_atd per_periods_of_service.actual_termination_date%TYPE;
4144: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
4145: l_rule_value pay_legislation_rules.rule_mode%TYPE;
4146: l_rule_found BOOLEAN;
4147: --
4148: -- 115.57 (END)

Line 4181: from per_periods_of_service

4177: -- Code changes for Bug#14140116 Starts here --
4178:
4179: cursor csr_earliest_date is
4180: select min(date_start)
4181: from per_periods_of_service
4182: where p_person_id = person_id;
4183:
4184: l_earliest_date date;
4185:

Line 4606: if per_periods_of_service_pkg_v2.IsBackToBackContract(p_person_id, l_effective_date) then

4602:
4603: -- PTU : Following Code has been added
4604:
4605: --start changes for bug8506648
4606: if per_periods_of_service_pkg_v2.IsBackToBackContract(p_person_id, l_effective_date) then
4607: hr_per_type_usage_internal.maintain_person_type_usage
4608: (p_effective_date => l_effective_date
4609: ,p_person_id => p_person_id
4610: ,p_person_type_id => l_person_type_id

Line 5553: FROM per_periods_of_service pds

5549: ,pds.date_start
5550: ,pds.actual_termination_date
5551: ,pds.last_standard_process_date
5552: ,pds.final_process_date
5553: FROM per_periods_of_service pds
5554: WHERE pds.person_id = p_person_id
5555: AND pds.date_start < p_rehire_date
5556: ORDER BY pds.date_start DESC;
5557: --