APPS.HRI_EDW_DIM_PERSON_TYPE dependencies on PER_PERSON_TYPES

Line 124: ,per_person_types ppt

120: CURSOR type_usages_cur IS
121: /* Person type usages includes basic person type */
122: SELECT ppt.system_person_type, ppt.user_person_type
123: FROM per_person_type_usages_f ptu
124: ,per_person_types ppt
125: WHERE ptu.person_id = p_person_id
126: AND TRUNC(p_effective_date)
127: BETWEEN ptu.effective_start_date AND ptu.effective_end_date
128: AND ptu.person_type_id = ppt.person_type_id;