[Home] [Help]
445: and ( pcr.date_start is NULL OR p_date_earned BETWEEN
446: pcr.date_start AND NVL(pcr.date_end, p_date_earned) )
447: and (pcr.date_start IS NOT NULL OR
448: EXISTS (SELECT person_id
449: FROM per_all_people_f
450: WHERE person_id = pcr.contact_person_id
451: AND p_date_earned BETWEEN
452: effective_start_date AND effective_end_date));
453: