DBA Data[Home] [Help]

APPS.PER_PERIODS_OF_SERVICE_PKG dependencies on PER_ALL_PEOPLE_F

Line 985: from per_all_people_f

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

Line 1751: from per_all_people_f p,

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