DBA Data[Home] [Help]

APPS.PQP_PERASGADD_RIW dependencies on PER_PERSON_TYPE_USAGES_F

Line 248: from per_person_type_usages_f ptu

244: ,ptu.person_type_id
245: ,ppt.active_flag
246: ,ppt.system_person_type
247: ,ppt.user_person_type
248: from per_person_type_usages_f ptu
249: ,per_person_types ppt
250: where ptu.person_id = c_person_id
251: and ppt.business_group_id = c_business_group_id
252: and ppt.person_type_id = ptu.person_type_id

Line 269: from per_person_type_usages_f ptu

265: ,c_business_group_id in number) is
266: select ptu.person_type_id
267: ,ppt.system_person_type
268: ,ppt.user_person_type
269: from per_person_type_usages_f ptu
270: ,per_person_types ppt
271: where ptu.person_id = c_person_id
272: and ppt.person_type_id = ptu.person_type_id
273: and ppt.business_group_id = c_business_group_id

Line 2069: ,per_person_type_usages_f ptu

2065: ,ptu.person_type_id
2066: ,ppf.person_id
2067: ,ppf.object_version_number
2068: from per_all_people_f ppf
2069: ,per_person_type_usages_f ptu
2070: ,per_person_types ppt
2071: where ptu.person_type_id = ppf.person_type_id
2072: and ppt.person_type_id = ptu.person_type_id
2073: and ppt.business_group_id = ppf.business_group_id