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 2327: per_person_types ppt

2323:
2324: cursor c_person_type is
2325: SELECT 'x'
2326: FROM per_person_type_usages_f ptu ,
2327: per_person_types ppt
2328: WHERE ptu.person_id = p_person_id
2329: and ptu.person_type_id = ppt.person_type_id
2330: and ppt.system_person_type in ('SRVNG_FMLY_MMBR','SRVNG_SPS')
2331: AND p_effective_date between ptu.effective_start_date and