4999: --
5000: cursor csr_chk_contig_ass is
5001:
5002: select null
5003: from sys.dual
5004: where exists(select null
5005: from per_all_assignments_f pas
5006: , per_periods_of_service ppos
5007: where pas.effective_start_date <= p_effective_date