APPS.PAY_GB_EOY_ARCHIVE dependencies on STANDARD

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

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

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

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