DBA Data[Home] [Help]

APPS.HR_PSF_BUS dependencies on HR_LOCATIONS

Line 2547: from hr_locations loc

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:

Line 2608: -- Check that the location exists in HR_LOCATIONS

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