APPS.HXC_TCC_BUS dependencies on DUAL

Line 109: FROM sys.dual

105: -- cursor to check mapping component id is valid
106:
107: CURSOR csr_chk_mpc_id IS
108: SELECT 'ok'
109: FROM sys.dual
110: WHERE EXISTS (
111: SELECT 'x'
112: FROM hxc_mapping_components mpc
113: WHERE mpc.mapping_component_id = p_component_type_id );

Line 193: FROM sys.dual

189: -- cursor to check time category code is valid
190:
191: CURSOR csr_chk_time_category_code IS
192: SELECT 'ok'
193: FROM sys.dual
194: WHERE EXISTS (
195: SELECT 'x'
196: FROM hxc_time_categories htc
197: WHERE htc.time_category_id = p_ref_time_category_id );

Line 201: FROM sys.dual

197: WHERE htc.time_category_id = p_ref_time_category_id );
198:
199: CURSOR csr_chk_code IS
200: SELECT 'error'
201: FROM sys.dual
202: WHERE EXISTS (
203: SELECT 'x'
204: FROM hxc_time_category_comps mpc
205: WHERE mpc.time_category_id = p_time_category_id

Line 443: FROM sys.dual

439: -- cursor to check mapping component is not duplicated
440: --
441: CURSOR csr_chk_mpc IS
442: SELECT 'error'
443: FROM sys.dual
444: WHERE EXISTS (
445: SELECT 'x'
446: FROM hxc_time_category_comps mpc
447: WHERE mpc.time_category_id = p_time_category_id

Line 532: FROM dual

528: ) IS
529:
530: CURSOR csr_chk_flex_value_set_id IS
531: SELECT 'ok'
532: FROM dual
533: WHERE EXISTS (
534: select 1
535: FROM fnd_flex_value_sets
536: WHERE flex_value_set_id = p_flex_value_set_id );