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