DBA Data[Home] [Help]

APPS.BEN_CWB_SINGLE_PER_PROCESS_PKG dependencies on PER_PERSON_TYPES

Line 429: ,per_person_types ppt

425: cursor csr_person_type(p_person_id number
426: ,p_effective_date date) is
427: select ppt.system_person_type
428: from per_person_type_usages_f ptu
429: ,per_person_types ppt
430: where ptu.person_id = p_person_id
431: and p_effective_date between ptu.effective_start_date
432: and ptu.effective_end_date
433: and ptu.person_type_id = ppt.person_type_id