APPS.PAY_CA_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 1810: per_all_people_f people

1806: people.national_identifier social_insurance_number,
1807: people.middle_names middle_names,
1808: decode (people.correspondence_language, 'FRC','F','E') correspondence_language
1809: from
1810: per_all_people_f people
1811: , per_person_types ptype
1812: , per_phones phone
1813: , fnd_sessions ses
1814: , hr_lookups a

Line 1833: AND PHONE.parent_table (+)= 'PER_ALL_PEOPLE_F'

1829: PEOPLE.effective_start_date
1830: AND PEOPLE.effective_end_date
1831: and PTYPE.person_type_id = PEOPLE.person_type_id
1832: and PHONE.parent_id (+) = PEOPLE.person_id
1833: AND PHONE.parent_table (+)= 'PER_ALL_PEOPLE_F'
1834: and PHONE.phone_type (+)= 'W1'
1835: AND l_effective_date
1836: BETWEEN NVL(PHONE.date_from(+),l_effective_date)
1837: AND NVL(PHONE.date_to(+),l_effective_date)

Line 1963: , per_all_people_f people1

1959: , hr_locations loc
1960: , hr_all_organization_units org
1961: , pay_people_groups grp
1962: , per_all_vacancies vac
1963: , per_all_people_f people1
1964: , per_all_people_f people2
1965: , per_all_positions pos1
1966: , per_all_positions pos2
1967: , per_all_positions pos3

Line 1964: , per_all_people_f people2

1960: , hr_all_organization_units org
1961: , pay_people_groups grp
1962: , per_all_vacancies vac
1963: , per_all_people_f people1
1964: , per_all_people_f people2
1965: , per_all_positions pos1
1966: , per_all_positions pos2
1967: , per_all_positions pos3
1968: , hr_lookups hr1