APPS.PAY_CA_ARCHIVE dependencies on HR_LOOKUPS

Line 1818: , hr_lookups a

1814: per_all_people_f people
1815: , per_person_types ptype
1816: , per_phones phone
1817: , fnd_sessions ses
1818: , hr_lookups a
1819: , hr_lookups c
1820: , hr_lookups d
1821: , hr_lookups e
1822: , hr_lookups f

Line 1819: , hr_lookups c

1815: , per_person_types ptype
1816: , per_phones phone
1817: , fnd_sessions ses
1818: , hr_lookups a
1819: , hr_lookups c
1820: , hr_lookups d
1821: , hr_lookups e
1822: , hr_lookups f
1823: , hr_lookups g

Line 1820: , hr_lookups d

1816: , per_phones phone
1817: , fnd_sessions ses
1818: , hr_lookups a
1819: , hr_lookups c
1820: , hr_lookups d
1821: , hr_lookups e
1822: , hr_lookups f
1823: , hr_lookups g
1824: , hr_lookups h

Line 1821: , hr_lookups e

1817: , fnd_sessions ses
1818: , hr_lookups a
1819: , hr_lookups c
1820: , hr_lookups d
1821: , hr_lookups e
1822: , hr_lookups f
1823: , hr_lookups g
1824: , hr_lookups h
1825: , hr_lookups i

Line 1822: , hr_lookups f

1818: , hr_lookups a
1819: , hr_lookups c
1820: , hr_lookups d
1821: , hr_lookups e
1822: , hr_lookups f
1823: , hr_lookups g
1824: , hr_lookups h
1825: , hr_lookups i
1826: , per_all_assignments_f ASSIGN

Line 1823: , hr_lookups g

1819: , hr_lookups c
1820: , hr_lookups d
1821: , hr_lookups e
1822: , hr_lookups f
1823: , hr_lookups g
1824: , hr_lookups h
1825: , hr_lookups i
1826: , per_all_assignments_f ASSIGN
1827: where l_effective_date BETWEEN

Line 1824: , hr_lookups h

1820: , hr_lookups d
1821: , hr_lookups e
1822: , hr_lookups f
1823: , hr_lookups g
1824: , hr_lookups h
1825: , hr_lookups i
1826: , per_all_assignments_f ASSIGN
1827: where l_effective_date BETWEEN
1828: ASSIGN.effective_start_date

Line 1825: , hr_lookups i

1821: , hr_lookups e
1822: , hr_lookups f
1823: , hr_lookups g
1824: , hr_lookups h
1825: , hr_lookups i
1826: , per_all_assignments_f ASSIGN
1827: where l_effective_date BETWEEN
1828: ASSIGN.effective_start_date
1829: AND ASSIGN.effective_end_date

Line 1972: , hr_lookups hr1

1968: , per_all_people_f people2
1969: , per_all_positions pos1
1970: , per_all_positions pos2
1971: , per_all_positions pos3
1972: , hr_lookups hr1
1973: , hr_lookups hr2
1974: , hr_lookups hr3
1975: , hr_lookups hr4
1976: , hr_lookups hr5

Line 1973: , hr_lookups hr2

1969: , per_all_positions pos1
1970: , per_all_positions pos2
1971: , per_all_positions pos3
1972: , hr_lookups hr1
1973: , hr_lookups hr2
1974: , hr_lookups hr3
1975: , hr_lookups hr4
1976: , hr_lookups hr5
1977: , hr_lookups hr6

Line 1974: , hr_lookups hr3

1970: , per_all_positions pos2
1971: , per_all_positions pos3
1972: , hr_lookups hr1
1973: , hr_lookups hr2
1974: , hr_lookups hr3
1975: , hr_lookups hr4
1976: , hr_lookups hr5
1977: , hr_lookups hr6
1978: , hr_lookups hr7

Line 1975: , hr_lookups hr4

1971: , per_all_positions pos3
1972: , hr_lookups hr1
1973: , hr_lookups hr2
1974: , hr_lookups hr3
1975: , hr_lookups hr4
1976: , hr_lookups hr5
1977: , hr_lookups hr6
1978: , hr_lookups hr7
1979: , fnd_lookups fnd1

Line 1976: , hr_lookups hr5

1972: , hr_lookups hr1
1973: , hr_lookups hr2
1974: , hr_lookups hr3
1975: , hr_lookups hr4
1976: , hr_lookups hr5
1977: , hr_lookups hr6
1978: , hr_lookups hr7
1979: , fnd_lookups fnd1
1980: , fnd_lookups fnd2

Line 1977: , hr_lookups hr6

1973: , hr_lookups hr2
1974: , hr_lookups hr3
1975: , hr_lookups hr4
1976: , hr_lookups hr5
1977: , hr_lookups hr6
1978: , hr_lookups hr7
1979: , fnd_lookups fnd1
1980: , fnd_lookups fnd2
1981: where

Line 1978: , hr_lookups hr7

1974: , hr_lookups hr3
1975: , hr_lookups hr4
1976: , hr_lookups hr5
1977: , hr_lookups hr6
1978: , hr_lookups hr7
1979: , fnd_lookups fnd1
1980: , fnd_lookups fnd2
1981: where
1982: l_effective_date BETWEEN assign.effective_start_date