DBA Data[Home] [Help]

APPS.HR_PDT_BUS dependencies on PER_PERIODS_OF_SERVICE

Line 547: per_periods_of_service pds

543: --
544: cursor csr_check_person(p_person_id number, p_effective_date in date) is
545: select 1
546: from per_all_people_f per,
547: per_periods_of_service pds
548: where per.person_id = p_person_id
549: and p_effective_date between
550: per.effective_start_date and per.effective_end_date
551: and per.business_group_id = p_from_business_group_id