Line 380: from per_periods_of_service s, per_people_f p
376:
377: if (l_assigned_to(l_count) is not null) then
378: select count(*)
379: into l_rowcount 380: from per_periods_of_service s, per_people_f p 381: where p.person_id = s.person_id
382: and trunc(l_trans_date) between
383: p.effective_start_date and p.effective_end_date
384: and nvl(s.actual_termination_date,l_trans_date) >= l_trans_date
[Home] [Help]