APPS.PAY_GB_EOY_ARCHIVE dependencies on STANDARD

Line 3178: SELECT distinct greatest(ppos.final_process_date,ppos.last_standard_process_date)

3174: AND flex.segment1 = p_tax_ref;
3175: --
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;

Line 3262: SELECT actual_termination_date , last_standard_process_date, 'L' termination_type

3258: AND proll.soft_coding_keyflex_id = pflex.soft_coding_keyflex_id
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