DBA Data[Home] [Help]

APPS.HXC_RETRIEVAL_RULE_GRP_API dependencies on DUAL

Line 427: FROM sys.dual

423: -- cursor to check name is unique
424: --
425: CURSOR csr_chk_name IS
426: SELECT 'error'
427: FROM sys.dual
428: WHERE EXISTS (
429: SELECT 'x'
430: FROM hxc_entity_groups heg
431: WHERE heg.name = p_name

Line 499: FROM sys.dual

495: --
496: /*
497: CURSOR csr_chk_pref IS
498: SELECT 'exists'
499: FROM sys.dual
500: WHERE EXISTS (
501: SELECT 'x'
502: FROM hxc_resource_all_elig_pref_v
503: WHERE preference_code = 'TS_PER_RETRIEVAL_RULES'