271: -- cursor to check that a duplicate approval period set name is not entered
272: --
273: CURSOR csr_chk_name IS
274: SELECT 'error' 275: FROM sys.dual 276: WHERE EXISTS (
277: SELECT 'x'
278: FROM hxc_approval_period_sets aps
279: WHERE aps.name = p_name