DBA Data[Home] [Help]

APPS.PQP_PERASGADD_RIW dependencies on PER_PERSON_TYPE_USAGES_F

Line 249: from per_person_type_usages_f ptu

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

Line 270: from per_person_type_usages_f ptu

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

Line 2171: ,per_person_type_usages_f ptu

2167: ,ptu.person_type_id
2168: ,ppf.person_id
2169: ,ppf.object_version_number
2170: from per_all_people_f ppf
2171: ,per_person_type_usages_f ptu
2172: ,per_person_types ppt
2173: where ptu.person_type_id = ppf.person_type_id
2174: and ppt.person_type_id = ptu.person_type_id
2175: and ppt.business_group_id = ppf.business_group_id