105: SELECT
106: ppttl.user_person_type,
107: ppt.system_person_type
108: FROM
109: per_person_types_tl ppttl,
110: per_person_types ppt
111: WHERE
112: ppt.person_type_id=p_person_type_id
113: and ppt.active_flag = 'Y'
106: ppttl.user_person_type,
107: ppt.system_person_type
108: FROM
109: per_person_types_tl ppttl,
110: per_person_types ppt
111: WHERE
112: ppt.person_type_id=p_person_type_id
113: and ppt.active_flag = 'Y'
114: and ppttl.person_type_id = ppt.person_type_id