DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_PERSON_TYPES

Line 109: per_person_types_tl ppttl,

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'

Line 110: per_person_types ppt

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