[Home] [Help]
616: where person_id = p_person_id
617: and date_start <= p_31dec
618: union all
619: select date_start
620: from per_periods_of_placement
621: where person_id = p_person_id
622: and date_start <= p_31dec);
623: p_hire_year := to_number(to_char(l_date_start,'YYYY'));
624: --