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

Line 261: l_old_final_process_date per_periods_of_service.final_process_date%TYPE;

257:
258: --
259: -- 115.9 (START)
260: --
261: l_old_final_process_date per_periods_of_service.final_process_date%TYPE;
262: --
263: -- 115.9 (END)
264: --
265: -- Fix for Bug 5152193 Starts here

Line 267: l_pds_rec per_periods_of_service%rowtype;

263: -- 115.9 (END)
264: --
265: -- Fix for Bug 5152193 Starts here
266:
267: l_pds_rec per_periods_of_service%rowtype;
268: l_per_rec per_all_people_f%rowtype;
269: l_orig_hire_warning boolean;
270: l_dob_null_warning boolean;
271: l_name_combination_warning boolean;

Line 274: select * from per_periods_of_service

270: l_dob_null_warning boolean;
271: l_name_combination_warning boolean;
272:
273: cursor csr_get_pds_details is
274: select * from per_periods_of_service
275: where period_of_service_id = p_period_of_service_id;
276:
277: cursor csr_get_per_rec(p_person_id number,p_date date) is
278: select * from per_all_people_f

Line 780: ,per_periods_of_service pds

776: SELECT NULL
777: FROM pay_payroll_actions ppa
778: ,pay_assignment_actions paa
779: ,per_assignments_f asg
780: ,per_periods_of_service pds
781: WHERE pds.period_of_service_id = p_period_of_service_id
782: AND pds.person_id = asg.person_id
783: AND asg.period_of_service_id = pds.period_of_service_id
784: AND asg.assignment_id = paa.assignment_id

Line 801: ,per_periods_of_service pds

797: ,asg.effective_end_date
798: ,asg.object_version_number
799: ,pds.actual_termination_date
800: FROM per_assignments_f asg
801: ,per_periods_of_service pds
802: WHERE pds.period_of_service_id = p_period_of_service_id
803: AND pds.person_id = asg.person_id
804: AND pds.period_of_service_id = asg.period_of_service_id
805: AND asg.effective_end_date = p_old_final_process_date;

Line 809: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

805: AND asg.effective_end_date = p_old_final_process_date;
806: --
807: l_assignment_id per_assignments_f.assignment_id%TYPE;
808: l_object_version_number per_assignments_f.object_version_number%TYPE;
809: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
810: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
811: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
812: l_new_final_process_date per_periods_of_service.final_process_date%TYPE;
813: --

Line 812: l_new_final_process_date per_periods_of_service.final_process_date%TYPE;

808: l_object_version_number per_assignments_f.object_version_number%TYPE;
809: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
810: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
811: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
812: l_new_final_process_date per_periods_of_service.final_process_date%TYPE;
813: --
814: -- 115.16 (START)
815: --
816: --l_org_now_no_manager_warning BOOLEAN;

Line 838: ,per_periods_of_service pds

834: --
835: CURSOR csr_asgs IS
836: SELECT NULL
837: FROM per_assignments_f asg
838: ,per_periods_of_service pds
839: WHERE pds.period_of_service_id = p_period_of_service_id
840: AND pds.period_of_service_id = asg.period_of_service_id
841: AND pds.person_id = asg.person_id
842: AND asg.effective_end_date = p_old_final_process_date;