APPS.HR_PERSON_RECORD dependencies on PER_PERSON_TYPES

Line 249: per_person_types ppt,

245: CURRENT_NPW_FLAG,
246: GLOBAL_NAME,
247: LOCAL_NAME
248: FROM PER_PEOPLE_F ppf,
249: per_person_types ppt,
250: per_person_types_v pptl,
251: per_person_type_usages_f pptu
252: where ppf.person_id = p_person_id
253: and ppf.business_group_id = p_business_group_id

Line 250: per_person_types_v pptl,

246: GLOBAL_NAME,
247: LOCAL_NAME
248: FROM PER_PEOPLE_F ppf,
249: per_person_types ppt,
250: per_person_types_v pptl,
251: per_person_type_usages_f pptu
252: where ppf.person_id = p_person_id
253: and ppf.business_group_id = p_business_group_id
254: and ppt.person_type_id = pptl.person_type_id

Line 1600: ,per_person_types ppt

1596: open srch_filtrd for
1597:
1598: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
1599: from per_people_f ppf
1600: ,per_person_types ppt
1601: ,per_phones pp
1602: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
1603: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date
1604: and ppf.person_id = pp.parent_id(+)

Line 1618: ,per_person_types ppt

1614: open srch_filtrd for
1615:
1616: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
1617: from per_people_f ppf
1618: ,per_person_types ppt
1619: ,per_qualifications pq
1620: ,per_establishment_attendances pea
1621: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
1622: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date

Line 1637: ,per_person_types ppt

1633: open srch_filtrd for
1634:
1635: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
1636: from per_people_f ppf
1637: ,per_person_types ppt
1638: ,per_person_dlvry_methods ppdm
1639: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
1640: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date
1641: and ppdm.person_id = ppf.person_id

Line 1654: ,per_person_types ppt

1650: open srch_filtrd for
1651:
1652: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
1653: from per_people_f ppf
1654: ,per_person_types ppt
1655: ,per_addresses pa
1656: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
1657: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date
1658: and pa.person_id = ppf.person_id

Line 1668: from per_people_f ppf ,per_person_types ppt ,per_assignments_f paaf

1664: ELSE
1665: open srch_filtrd for
1666:
1667: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
1668: from per_people_f ppf ,per_person_types ppt ,per_assignments_f paaf
1669: where nvl(p_srch_criteria(i).p_person_id, ppf.person_id) = ppf.person_id
1670: and ppf.person_id between nvl(p_srch_criteria(i).p_start_person_id, ppf.person_id)
1671: and nvl(p_srch_criteria(i).p_end_person_id, ppf.person_id)
1672: and ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)