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

Line 123: per_person_types_tl ppttl,

119: pptuf.person_type_id,
120: ppttl.user_person_type,
121: ppt.system_person_type
122: FROM
123: per_person_types_tl ppttl,
124: per_person_types ppt,
125: per_person_types ppt1,
126: per_person_type_usages_f pptuf
127: WHERE

Line 124: per_person_types ppt,

120: ppttl.user_person_type,
121: ppt.system_person_type
122: FROM
123: per_person_types_tl ppttl,
124: per_person_types ppt,
125: per_person_types ppt1,
126: per_person_type_usages_f pptuf
127: WHERE
128: pptuf.person_id = p_person_id

Line 125: per_person_types ppt1,

121: ppt.system_person_type
122: FROM
123: per_person_types_tl ppttl,
124: per_person_types ppt,
125: per_person_types ppt1,
126: per_person_type_usages_f pptuf
127: WHERE
128: pptuf.person_id = p_person_id
129: and l_effective_date between pptuf.effective_start_date and pptuf.effective_end_date

Line 140: per_person_types ppt WHERE

136:
137: cursor csr_person_type_new_1(p_person_id number,l_effective_date date,p_system_person_type VARCHAR2) is
138: SELECT ptu.person_type_id FROM
139: per_person_type_usages_f ptu,
140: per_person_types ppt WHERE
141: ptu.person_id = p_person_id
142: and l_effective_date between ptu.effective_start_date and ptu.effective_end_date
143: and ptu.person_type_id = ppt.person_type_id and ppt.system_person_type=p_system_person_type;
144: