APPS.PAY_GB_EOY_ARCHIVE dependencies on PER_PERIODS_OF_SERVICE

Line 3180: per_periods_of_service ppos

3176: -- Bug fix for 3699865 - this cursor will retrieve the final process date of the assignment
3177: cursor csr_asg_last_process_date(p_assid NUMBER) IS
3178: SELECT distinct greatest(ppos.final_process_date,ppos.last_standard_process_date)
3179: FROM per_all_assignments_f paaf,
3180: per_periods_of_service ppos
3181: WHERE paaf.assignment_id = p_assid
3182: AND paaf.period_of_service_id = ppos.period_of_service_id;
3183: --
3184: cursor csr_basic_asg_info (p_assid NUMBER, p_eff_end_date DATE) IS

Line 3263: FROM per_periods_of_service pos

3259: AND flex.segment1 <> pflex.segment1;
3260: --
3261: cursor csr_termination(p_service_id NUMBER, p_asg_end DATE) IS
3262: SELECT actual_termination_date , last_standard_process_date, 'L' termination_type
3263: FROM per_periods_of_service pos
3264: WHERE pos.period_of_service_id = p_service_id
3265: AND pos.actual_termination_date IS NOT NULL
3266: AND pos.actual_termination_date
3267: <= least(p_asg_end,g_end_year);