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.PER_PYP_BUS dependencies on PER_PERIODS_OF_SERVICE

Line 292: from per_periods_of_service pds

288: cursor csr_pds_final_process_date is
289: select final_process_date,
290: last_standard_process_date,
291: actual_termination_date
292: from per_periods_of_service pds
293: , per_all_assignments_f asg
294: where asg.assignment_id=p_assignment_id
295: and p_change_date between asg.effective_start_date and asg.effective_end_date
296: and asg.person_id=pds.person_id

Line 340: l_pds_final_process_date per_periods_of_service.final_process_date%TYPE;

336: --
337: l_exists varchar2(1);
338: l_effective_end_date date;
339: l_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
340: l_pds_final_process_date per_periods_of_service.final_process_date%TYPE;
341: --4073821
342: l_pds_last_std_proc_date per_periods_of_service.last_standard_process_date%TYPE;
343: l_pds_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
344: l_ele_term_rule pay_element_types_f.post_termination_rule%TYPE;

Line 342: l_pds_last_std_proc_date per_periods_of_service.last_standard_process_date%TYPE;

338: l_effective_end_date date;
339: l_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
340: l_pds_final_process_date per_periods_of_service.final_process_date%TYPE;
341: --4073821
342: l_pds_last_std_proc_date per_periods_of_service.last_standard_process_date%TYPE;
343: l_pds_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
344: l_ele_term_rule pay_element_types_f.post_termination_rule%TYPE;
345:
346: l_proc varchar2(72) := g_package||'chk_pay_basis_change_date';

Line 343: l_pds_actual_term_date per_periods_of_service.actual_termination_date%TYPE;

339: l_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
340: l_pds_final_process_date per_periods_of_service.final_process_date%TYPE;
341: --4073821
342: l_pds_last_std_proc_date per_periods_of_service.last_standard_process_date%TYPE;
343: l_pds_actual_term_date per_periods_of_service.actual_termination_date%TYPE;
344: l_ele_term_rule pay_element_types_f.post_termination_rule%TYPE;
345:
346: l_proc varchar2(72) := g_package||'chk_pay_basis_change_date';
347: --