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