APPS.HR_PERSON_RECORD dependencies on PER_PEOPLE_F

Line 248: FROM PER_PEOPLE_F ppf,

244: NPW_NUMBER,
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

Line 497: , (SELECT FULL_NAME FROM PER_PEOPLE_F

493: -- cursor to fetch the contact information
494: CURSOR csr_contact_record(p_person_id number,p_business_group_id number,p_eff_date date) is
495: SELECT CONTACT_RELATIONSHIP_ID
496: , CONTACT_PERSON_ID
497: , (SELECT FULL_NAME FROM PER_PEOPLE_F
498: WHERE PERSON_ID = CONTACT_PERSON_ID
499: AND BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
500: AND P_EFF_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE) CONTACT_FULL_NAME
501: , CONTACT_TYPE

Line 1457: FROM per_assignments_f papf , per_people_f ppf

1453: papf.assignment_status_type_id,
1454: (SELECT USER_STATUS FROM PER_ASSIGNMENT_STATUS_TYPES_TL
1455: WHERE ASSIGNMENT_STATUS_TYPE_ID = papf.assignment_status_type_id
1456: AND LANGUAGE = USERENV('LANG')) REPORTEE_ASG_STATUS_DESC
1457: FROM per_assignments_f papf , per_people_f ppf
1458: WHERE
1459: p_eff_date BETWEEN papf.effective_start_date AND papf.effective_end_date
1460: and p_eff_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
1461: and papf.business_group_id = P_BUSINESS_GROUP_ID

Line 1599: from per_people_f ppf

1595: AND p_srch_criteria(i).p_person_id IS NULL THEN
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

Line 1617: from per_people_f ppf

1613: AND p_srch_criteria(i).p_person_id IS NULL THEN
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)

Line 1636: from per_people_f ppf

1632: AND p_srch_criteria(i).p_person_id IS NULL THEN
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

Line 1653: from per_people_f ppf

1649: AND p_srch_criteria(i).p_person_id IS NULL THEN
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

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)