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