DBA Data[Home] [Help]

APPS.BEN_CWB_UTILS dependencies on PER_PERSON_TYPES

Line 914: per_person_types ppt

910: CURSOR is_person_in_secured_view
911: is
912: SELECT 'x'
913: FROM per_people_f ppf,
914: per_person_types ppt
915: WHERE ppf.person_id = p_person_id
916: AND ppt.person_type_id = ppf.person_type_id
917: AND ppt.system_person_type <> 'EX_EMP_APL'
918: AND p_effective_date between ppf.effective_start_date and ppf.effective_end_date;