DBA Data[Home] [Help]

APPS.FA_DISTRIBUTION_PVT dependencies on PER_PEOPLE_F

Line 694: from per_periods_of_service s, per_people_f p

690: -- validate assigned_to
691: if (p_asset_dist_tbl(p_curr_index).assigned_to is not null) then
692: select count(*)
693: into l_count
694: from per_periods_of_service s, per_people_f p
695: where p.person_id = s.person_id
696: and trunc(sysdate) between
697: p.effective_start_date and p.effective_end_date
698: and nvl(s.actual_termination_date,sysdate) >= sysdate