DBA Data[Home] [Help]

APPS.PQP_HROSS_INTEGRATION dependencies on PER_PERSON_TYPE_USAGES_F

Line 190: FROM per_person_type_usages_f ptu

186: ,ptu.person_type_id
187: ,ppt.active_flag
188: ,ppt.system_person_type
189: ,ppt.user_person_type
190: FROM per_person_type_usages_f ptu
191: ,per_person_types ppt
192: WHERE ptu.person_id = c_person_id
193: AND ppt.business_group_id = c_business_group_id
194: AND ppt.person_type_id = ptu.person_type_id

Line 211: FROM per_person_type_usages_f ptu

207: ,c_business_group_id IN Number) Is
208: SELECT ptu.person_type_id
209: ,ppt.system_person_type
210: ,ppt.user_person_type
211: FROM per_person_type_usages_f ptu
212: ,per_person_types ppt
213: WHERE ptu.person_id = c_person_id
214: AND ppt.person_type_id = ptu.person_type_id
215: AND ppt.business_group_id = c_business_group_id