421: -- cursor to check name is unique
422: --
423: CURSOR csr_chk_name IS
424: SELECT 'error' 425: FROM sys.dual 426: WHERE EXISTS (
427: SELECT 'x'
428: FROM hxc_entity_groups heg
429: WHERE heg.name = p_name
Line 497: FROM sys.dual
493: --
494: /*
495: CURSOR csr_chk_pref IS
496: SELECT 'exists' 497: FROM sys.dual 498: WHERE EXISTS (
499: SELECT 'x'
500: FROM hxc_resource_all_elig_pref_v
501: WHERE preference_code = 'TS_PER_APPLICATION_SET'