DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on PER_PEOPLE_F

Line 1078: from per_periods_of_service s, per_people_f p

1074: if p_assigned_to is not null then
1075:
1076: select count(*)
1077: into l_rowcount
1078: from per_periods_of_service s, per_people_f p
1079: where p.person_id = s.person_id
1080: and trunc(p_date) between
1081: p.effective_start_date and p.effective_end_date
1082: and nvl(s.actual_termination_date,p_date) >= p_date