74: CURSOR csr_back_to_back IS
75: SELECT 'x'
76: FROM per_assignments_f asg1
77: ,per_assignments_f asg2
78: ,per_assignment_status_types pas1
79: ,per_assignment_status_types pas2
80: ,per_periods_of_service pds
81: WHERE pds.person_id = p_person_id
82: AND pds.person_id = asg1.person_id
75: SELECT 'x'
76: FROM per_assignments_f asg1
77: ,per_assignments_f asg2
78: ,per_assignment_status_types pas1
79: ,per_assignment_status_types pas2
80: ,per_periods_of_service pds
81: WHERE pds.person_id = p_person_id
82: AND pds.person_id = asg1.person_id
83: AND pds.person_id = asg2.person_id