DBA Data[Home] [Help]

APPS.HRI_OPL_EVENT_CAPTURE dependencies on PER_PERSON_TYPES

Line 433: per_person_types ppt

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