718: ,c_start_date date
719: ,c_end_date date) is
720: select 1
721: from per_jobs perj
722: ,per_jobs_tl perjtl
723: ,per_all_assignments_f paa
724: where paa.assignment_id = c_assignment_id
725: and c_start_date <= paa.effective_end_date
726: and c_end_date >= paa.effective_start_date