DBA Data[Home] [Help]

APPS.HXC_HTS_BUS dependencies on DUAL

Line 111: FROM sys.dual

107: -- cursor to check name is unique
108: --
109: CURSOR csr_chk_name IS
110: SELECT 'error'
111: FROM sys.dual
112: WHERE EXISTS (
113: SELECT 'x'
114: FROM hxc_time_sources tr
115: WHERE tr.name = p_name

Line 193: FROM sys.dual

189: l_used_elsewhere VARCHAR2(1) := 'N';
190:
191: CURSOR csr_chk_dep IS
192: SELECT 'Y'
193: FROM sys.dual
194: WHERE EXISTS (
195: SELECT 'x'
196: FROM hxc_deposit_processes dep
197: WHERE dep.time_source_id = p_time_source_id);