APPS.HXC_MPC_BUS dependencies on DUAL

Line 110: FROM sys.dual

106: -- cursor to check mapping name is not duplicated
107: --
108: CURSOR csr_chk_name IS
109: SELECT 'error'
110: FROM sys.dual
111: WHERE EXISTS (
112: SELECT 'x'
113: FROM hxc_mapping_components mpc
114: WHERE mpc.name = p_name

Line 196: FROM sys.dual

192: -- cursor to check building block category is valid
193: --
194: CURSOR csr_chk_bbc IS
195: SELECT 'error'
196: FROM sys.dual
197: WHERE NOT EXISTS (
198: SELECT 'x'
199: FROM hxc_bld_blk_info_type_usages bb
200: WHERE bb.bld_blk_info_type_id = p_bld_blk_info_type_id );

Line 384: FROM sys.dual

380: -- cursor to check key not duplicated
381:
382: CURSOR csr_chk_key IS
383: SELECT 'error'
384: FROM sys.dual
385: WHERE EXISTS (
386: SELECT 'x'
387: FROM hxc_mapping_components mpc
388: WHERE mpc.field_name = p_field_name

Line 526: FROM sys.dual

522: -- cursor to check mapping component is not referenced
523: --
524: CURSOR csr_chk_mcu IS
525: SELECT 'error'
526: FROM sys.dual
527: WHERE EXISTS (
528: SELECT 'x'
529: FROM hxc_mapping_comp_usages mcu
530: WHERE mcu.mapping_component_id = p_mapping_component_id );