APPS.PER_PERIODS_OF_SERVICE_PKG dependencies on PER_ALL_PEOPLE_F

Line 986: from per_all_people_f

982: attribute27,
983: attribute28,
984: attribute29,
985: attribute30
986: from per_all_people_f
987: where person_id = p_person_id
988: and p_date
989: between effective_start_date
990: and effective_end_date;

Line 1752: from per_all_people_f p,

1748: -- Cursor Terminated Per_id
1749: --
1750: cursor terminated_by is
1751: select p.full_name,nvl(p.employee_number, p.npw_number)
1752: from per_all_people_f p,
1753: per_periods_of_service pps
1754: where p.person_id = pps.termination_accepted_person_id
1755: and (p.business_group_id = p_business_group_id OR
1756: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y')