APPS.PAY_CA_ARCHIVE dependencies on HR_LOOKUPS

Line 1814: , hr_lookups a

1810: per_all_people_f people
1811: , per_person_types ptype
1812: , per_phones phone
1813: , fnd_sessions ses
1814: , hr_lookups a
1815: , hr_lookups c
1816: , hr_lookups d
1817: , hr_lookups e
1818: , hr_lookups f

Line 1815: , hr_lookups c

1811: , per_person_types ptype
1812: , per_phones phone
1813: , fnd_sessions ses
1814: , hr_lookups a
1815: , hr_lookups c
1816: , hr_lookups d
1817: , hr_lookups e
1818: , hr_lookups f
1819: , hr_lookups g

Line 1816: , hr_lookups d

1812: , per_phones phone
1813: , fnd_sessions ses
1814: , hr_lookups a
1815: , hr_lookups c
1816: , hr_lookups d
1817: , hr_lookups e
1818: , hr_lookups f
1819: , hr_lookups g
1820: , hr_lookups h

Line 1817: , hr_lookups e

1813: , fnd_sessions ses
1814: , hr_lookups a
1815: , hr_lookups c
1816: , hr_lookups d
1817: , hr_lookups e
1818: , hr_lookups f
1819: , hr_lookups g
1820: , hr_lookups h
1821: , hr_lookups i

Line 1818: , hr_lookups f

1814: , hr_lookups a
1815: , hr_lookups c
1816: , hr_lookups d
1817: , hr_lookups e
1818: , hr_lookups f
1819: , hr_lookups g
1820: , hr_lookups h
1821: , hr_lookups i
1822: , per_all_assignments_f ASSIGN

Line 1819: , hr_lookups g

1815: , hr_lookups c
1816: , hr_lookups d
1817: , hr_lookups e
1818: , hr_lookups f
1819: , hr_lookups g
1820: , hr_lookups h
1821: , hr_lookups i
1822: , per_all_assignments_f ASSIGN
1823: where l_effective_date BETWEEN

Line 1820: , hr_lookups h

1816: , hr_lookups d
1817: , hr_lookups e
1818: , hr_lookups f
1819: , hr_lookups g
1820: , hr_lookups h
1821: , hr_lookups i
1822: , per_all_assignments_f ASSIGN
1823: where l_effective_date BETWEEN
1824: ASSIGN.effective_start_date

Line 1821: , hr_lookups i

1817: , hr_lookups e
1818: , hr_lookups f
1819: , hr_lookups g
1820: , hr_lookups h
1821: , hr_lookups i
1822: , per_all_assignments_f ASSIGN
1823: where l_effective_date BETWEEN
1824: ASSIGN.effective_start_date
1825: AND ASSIGN.effective_end_date

Line 1968: , hr_lookups hr1

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
1969: , hr_lookups hr2
1970: , hr_lookups hr3
1971: , hr_lookups hr4
1972: , hr_lookups hr5

Line 1969: , hr_lookups hr2

1965: , per_all_positions pos1
1966: , per_all_positions pos2
1967: , per_all_positions pos3
1968: , hr_lookups hr1
1969: , hr_lookups hr2
1970: , hr_lookups hr3
1971: , hr_lookups hr4
1972: , hr_lookups hr5
1973: , hr_lookups hr6

Line 1970: , hr_lookups hr3

1966: , per_all_positions pos2
1967: , per_all_positions pos3
1968: , hr_lookups hr1
1969: , hr_lookups hr2
1970: , hr_lookups hr3
1971: , hr_lookups hr4
1972: , hr_lookups hr5
1973: , hr_lookups hr6
1974: , hr_lookups hr7

Line 1971: , hr_lookups hr4

1967: , per_all_positions pos3
1968: , hr_lookups hr1
1969: , hr_lookups hr2
1970: , hr_lookups hr3
1971: , hr_lookups hr4
1972: , hr_lookups hr5
1973: , hr_lookups hr6
1974: , hr_lookups hr7
1975: , fnd_lookups fnd1

Line 1972: , hr_lookups hr5

1968: , hr_lookups hr1
1969: , hr_lookups hr2
1970: , hr_lookups hr3
1971: , hr_lookups hr4
1972: , hr_lookups hr5
1973: , hr_lookups hr6
1974: , hr_lookups hr7
1975: , fnd_lookups fnd1
1976: , fnd_lookups fnd2

Line 1973: , hr_lookups hr6

1969: , hr_lookups hr2
1970: , hr_lookups hr3
1971: , hr_lookups hr4
1972: , hr_lookups hr5
1973: , hr_lookups hr6
1974: , hr_lookups hr7
1975: , fnd_lookups fnd1
1976: , fnd_lookups fnd2
1977: where

Line 1974: , hr_lookups hr7

1970: , hr_lookups hr3
1971: , hr_lookups hr4
1972: , hr_lookups hr5
1973: , hr_lookups hr6
1974: , hr_lookups hr7
1975: , fnd_lookups fnd1
1976: , fnd_lookups fnd2
1977: where
1978: l_effective_date BETWEEN assign.effective_start_date