APPS.HXC_MAP_BUS dependencies on DUAL

Line 100: FROM sys.dual

96: -- cursor to check name does not overlap
97: --
98: CURSOR csr_chk_name IS
99: SELECT 'error'
100: FROM sys.dual
101: WHERE EXISTS (
102: SELECT 'x'
103: FROM hxc_mappings map
104: WHERE map.name = p_name AND

Line 174: FROM sys.dual

170: l_proc varchar2(72);
171: --
172: CURSOR csr_chk_dar IS
173: SELECT 'exists'
174: FROM sys.dual
175: WHERE EXISTS (
176: SELECT 'x'
177: FROM hxc_time_entry_rules dar
178: WHERE dar.mapping_id = p_mapping_id);

Line 183: FROM sys.dual

179: --
180: --
181: CURSOR csr_chk_dep IS
182: SELECT 'exists'
183: FROM sys.dual
184: WHERE EXISTS (
185: SELECT 'x'
186: FROM hxc_deposit_processes dep
187: WHERE dep.mapping_id = p_mapping_id);

Line 192: FROM sys.dual

188: --
189: --
190: CURSOR csr_chk_ret IS
191: SELECT 'exists'
192: FROM sys.dual
193: WHERE EXISTS (
194: SELECT 'x'
195: FROM hxc_retrieval_processes ret
196: WHERE ret.mapping_id = p_mapping_id);