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 2547: l_period_of_service_id per_periods_of_service.period_of_service_id%type;

2543: l_applicant_number per_people_f.applicant_number%TYPE;
2544: l_npw_number per_people_f.npw_number%type;
2545: l_full_name per_people_f.full_name%type;
2546: l_object_version_number per_people_f.object_version_number%type;
2547: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
2548: l_pds_object_version_number per_periods_of_service.object_version_number%type;
2549: l_datetrack_mode varchar2(12);
2550: l_effective_date date;
2551: l_hire_date date;

Line 2548: l_pds_object_version_number per_periods_of_service.object_version_number%type;

2544: l_npw_number per_people_f.npw_number%type;
2545: l_full_name per_people_f.full_name%type;
2546: l_object_version_number per_people_f.object_version_number%type;
2547: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
2548: l_pds_object_version_number per_periods_of_service.object_version_number%type;
2549: l_datetrack_mode varchar2(12);
2550: l_effective_date date;
2551: l_hire_date date;
2552: l_assign_payroll_warning boolean :=FALSE;

Line 2710: l_final_process_date per_periods_of_service.final_process_date%type;

2706: p_employee_number out nocopy varchar2) is
2707: --
2708: l_proc varchar2(72) := g_package||'perform_validation';
2709: l_system_person_type per_person_types.system_person_type%type;
2710: l_final_process_date per_periods_of_service.final_process_date%type;
2711: l_effective_start_date per_people_f.effective_start_date%type;
2712: l_dummy_number number;
2713: l_dummy_emp_number varchar2(30);
2714: l_dummy_date date;

Line 2727: from per_periods_of_service pos

2723: pos.final_process_date
2724: --
2725: -- 115.57 (END)
2726: --
2727: from per_periods_of_service pos
2728: where pos.person_id = p_person_id
2729: order by pos.date_start desc;
2730: --
2731: -- 115.57 (START)

Line 2733: l_fpd per_periods_of_service.final_process_date%TYPE;

2729: order by pos.date_start desc;
2730: --
2731: -- 115.57 (START)
2732: --
2733: l_fpd per_periods_of_service.final_process_date%TYPE;
2734: l_atd per_periods_of_service.actual_termination_date%TYPE;
2735: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
2736: --
2737: -- Cursor to get legislation code

Line 2734: l_atd per_periods_of_service.actual_termination_date%TYPE;

2730: --
2731: -- 115.57 (START)
2732: --
2733: l_fpd per_periods_of_service.final_process_date%TYPE;
2734: l_atd per_periods_of_service.actual_termination_date%TYPE;
2735: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
2736: --
2737: -- Cursor to get legislation code
2738: --

Line 2735: l_lspd per_periods_of_service.last_standard_process_date%TYPE;

2731: -- 115.57 (START)
2732: --
2733: l_fpd per_periods_of_service.final_process_date%TYPE;
2734: l_atd per_periods_of_service.actual_termination_date%TYPE;
2735: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
2736: --
2737: -- Cursor to get legislation code
2738: --
2739: CURSOR csr_per_legislation

Line 3800: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;

3796: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
3797: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
3798: l_full_name per_all_people_f.full_name%TYPE;
3799: l_name_combination_warning BOOLEAN;
3800: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
3801: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
3802: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3803: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3804: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

Line 3801: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;

3797: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
3798: l_full_name per_all_people_f.full_name%TYPE;
3799: l_name_combination_warning BOOLEAN;
3800: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
3801: l_pds_object_version_number per_periods_of_service.object_version_number%TYPE;
3802: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3803: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3804: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3805: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

Line 3810: l_final_process_date per_periods_of_service.final_process_date%type;

3806: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
3807: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
3808: --
3809: -- Start of fix for bug 3143299
3810: l_final_process_date per_periods_of_service.final_process_date%type;
3811: --
3812: -- Local cursors
3813: cursor csr_chk_period_of_service is
3814: --

Line 3824: from per_periods_of_service pos

3820: pos.final_process_date
3821: --
3822: -- 115.57 (END)
3823: --
3824: from per_periods_of_service pos
3825: where pos.person_id = p_person_id
3826: order by pos.date_start desc;
3827: --
3828: -- 115.57 (START)

Line 3830: l_fpd per_periods_of_service.final_process_date%TYPE;

3826: order by pos.date_start desc;
3827: --
3828: -- 115.57 (START)
3829: --
3830: l_fpd per_periods_of_service.final_process_date%TYPE;
3831: l_atd per_periods_of_service.actual_termination_date%TYPE;
3832: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
3833: l_rule_value pay_legislation_rules.rule_mode%TYPE;
3834: l_rule_found BOOLEAN;

Line 3831: l_atd per_periods_of_service.actual_termination_date%TYPE;

3827: --
3828: -- 115.57 (START)
3829: --
3830: l_fpd per_periods_of_service.final_process_date%TYPE;
3831: l_atd per_periods_of_service.actual_termination_date%TYPE;
3832: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
3833: l_rule_value pay_legislation_rules.rule_mode%TYPE;
3834: l_rule_found BOOLEAN;
3835: --

Line 3832: l_lspd per_periods_of_service.last_standard_process_date%TYPE;

3828: -- 115.57 (START)
3829: --
3830: l_fpd per_periods_of_service.final_process_date%TYPE;
3831: l_atd per_periods_of_service.actual_termination_date%TYPE;
3832: l_lspd per_periods_of_service.last_standard_process_date%TYPE;
3833: l_rule_value pay_legislation_rules.rule_mode%TYPE;
3834: l_rule_found BOOLEAN;
3835: --
3836: -- 115.57 (END)

Line 5207: FROM per_periods_of_service pds

5203: ,pds.date_start
5204: ,pds.actual_termination_date
5205: ,pds.last_standard_process_date
5206: ,pds.final_process_date
5207: FROM per_periods_of_service pds
5208: WHERE pds.person_id = p_person_id
5209: AND pds.date_start < p_rehire_date
5210: ORDER BY pds.date_start DESC;
5211: --