APPS.PAY_GB_EOY_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 3307: per_periods_of_service ppos

3303: -- Bug fix for 3699865 - this cursor will retrieve the final process date of the assignment
3304: cursor csr_asg_last_process_date(p_assid NUMBER) IS
3305: SELECT distinct greatest(ppos.final_process_date,ppos.last_standard_process_date)
3306: FROM per_all_assignments_f paaf,
3307: per_periods_of_service ppos
3308: WHERE paaf.assignment_id = p_assid
3309: AND paaf.period_of_service_id = ppos.period_of_service_id;
3310: --
3311: cursor csr_basic_asg_info (p_assid NUMBER, p_eff_end_date DATE) IS

Line 3390: FROM per_periods_of_service pos

3386: AND flex.segment1 <> pflex.segment1;
3387: --
3388: cursor csr_termination(p_service_id NUMBER, p_asg_end DATE) IS
3389: SELECT actual_termination_date , last_standard_process_date, 'L' termination_type
3390: FROM per_periods_of_service pos
3391: WHERE pos.period_of_service_id = p_service_id
3392: AND pos.actual_termination_date IS NOT NULL
3393: AND pos.actual_termination_date
3394: <= least(p_asg_end,g_end_year);