[Home] [Help]
293: -- employee or contingent worker on new interview date.
294:
295: cursor csr_person_exists(p_person_id in number) is
296: select 'Y'
297: from per_all_workforce_v
298: where person_id = p_person_id
299: and p_new_interview_start_date between effective_start_date
300: and effective_end_date;
301: l_dummy varchar2(1);