2543: l_inactive_date date;
2544: --
2545: cursor csr_valid_location is
2546: select 'x'
2547: from hr_locations loc
2548: where loc.location_id = p_location_id
2549: and p_effective_date < nvl(loc.inactive_date,
2550: hr_api.g_eot);
2551:
2604: end if;
2605: --
2606: if p_location_id is not null then
2607: --
2608: -- Check that the location exists in HR_LOCATIONS
2609: --
2610: open csr_valid_location;
2611: fetch csr_valid_location into l_exists;
2612: if csr_valid_location%notfound then