DBA Data[Home] [Help]

APPS.BEN_EXT_PERSON dependencies on PER_PERSON_TYPES

Line 562: per_person_types ppt

558: ,p.per_information29
559: ,p.per_information30
560: ,p.business_group_id
561: from per_all_people_f p,
562: per_person_types ppt
563: where
564: p.person_id = p_person_id
565: and p_effective_date between p.effective_start_date
566: and p.effective_end_date

Line 2293: per_person_types ppt

2289:
2290: cursor c_person_type is
2291: SELECT 'x'
2292: FROM per_person_type_usages_f ptu ,
2293: per_person_types ppt
2294: WHERE ptu.person_id = p_person_id
2295: and ptu.person_type_id = ppt.person_type_id
2296: and ppt.system_person_type in ('SRVNG_FMLY_MMBR','SRVNG_SPS')
2297: AND p_effective_date between ptu.effective_start_date and