DBA Data[Home] [Help]

APPS.HRI_OPL_EVENT_CAPTURE dependencies on PER_PERSON_TYPES

Line 436: per_person_types ppt

432: --
433: CURSOR c_ptu IS
434: SELECT 1
435: FROM per_person_type_usages_f ptu,
436: per_person_types ppt
437: WHERE 1=1
438: AND ptu.person_type_usage_id = p_person_type_usage_id
439: AND p_effective_date BETWEEN ptu.effective_start_date and ptu.effective_end_date
440: AND ptu.person_type_id = ppt.person_type_id