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
1979: AND assign.effective_end_date
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
1979: AND assign.effective_end_date
1980: and assign.assignment_id = l_assignment_id