DBA Data[Home] [Help]

APPS.FA_DISTRIBUTION_PVT dependencies on PER_PEOPLE_F

Line 826: from per_periods_of_service s, per_people_f p

822: -- validate assigned_to
823: if (p_asset_dist_tbl(p_curr_index).assigned_to is not null) then
824: select count(*)
825: into l_count
826: from per_periods_of_service s, per_people_f p
827: where p.person_id = s.person_id
828: and trunc(sysdate) between
829: p.effective_start_date and p.effective_end_date
830: and nvl(s.actual_termination_date,sysdate) >= sysdate