APPS.PER_SSM_BUS dependencies on HR_LOCATIONS

Line 719: from hr_locations loc

715: l_loc_date_to date;
716: --
717: cursor csr_chk_location_exists is
718: select inactive_date
719: from hr_locations loc
720: where loc.location_id = p_location_id and loc.location_use = 'HR'
721: ;
722: --
723: Begin

Line 740: -- raise error as FK does not relate to PK in hr_locations

736: hr_utility.set_location('Entering:'||l_proc,6);
737: --
738: close csr_chk_location_exists;
739: --
740: -- raise error as FK does not relate to PK in hr_locations
741: -- table.
742: --
743: per_ssm_shd.constraint_error('PER_SALARY_SURVEY_MAPPINGS_FK2');
744: --