DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on PER_PEOPLE_F

Line 864: from per_periods_of_service s, per_people_f p

860: if p_assigned_to is not null then
861:
862: select count(*)
863: into l_rowcount
864: from per_periods_of_service s, per_people_f p
865: where p.person_id = s.person_id
866: and trunc(p_date) between
867: p.effective_start_date and p.effective_end_date
868: and nvl(s.actual_termination_date,p_date) >= p_date