DBA Data[Home] [Help]

APPS.FA_MASSPTFR_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 978: from per_periods_of_service s,

974: if (p_to_employee_id is not null) then
975:
976: select count(*)
977: into l_to_employee_id_exists
978: from per_periods_of_service s,
979: per_people_f p
980: where p.person_id = p_to_employee_id
981: and p.person_id = s.person_id
982: and trunc(sysdate) between p.effective_start_date