APPS.HXC_HTR_BUS dependencies on DUAL

Line 48: FROM sys.dual

44: -- cursor to check name is unique
45: --
46: CURSOR csr_chk_name IS
47: SELECT 'error'
48: FROM sys.dual
49: WHERE EXISTS (
50: SELECT 'x'
51: FROM hxc_time_recipients tr
52: WHERE tr.name = p_name

Line 179: FROM sys.dual

175: l_used_elsewhere VARCHAR2(1) := 'N';
176:
177: CURSOR csr_chk_ret IS
178: SELECT 'Y'
179: FROM sys.dual
180: WHERE EXISTS (
181: SELECT 'x'
182: FROM hxc_retrieval_processes ret
183: WHERE ret.time_recipient_id = p_time_recipient_id);

Line 187: FROM sys.dual

183: WHERE ret.time_recipient_id = p_time_recipient_id);
184:
185: CURSOR csr_chk_rrc IS
186: SELECT 'Y'
187: FROM sys.dual
188: WHERE EXISTS (
189: SELECT 'x'
190: FROM hxc_retrieval_rule_comps rrc
191: WHERE rrc.time_recipient_id = p_time_recipient_id);

Line 195: FROM sys.dual

191: WHERE rrc.time_recipient_id = p_time_recipient_id);
192:
193: CURSOR csr_chk_apc IS
194: SELECT 'Y'
195: FROM sys.dual
196: WHERE EXISTS (
197: SELECT 'x'
198: FROM hxc_approval_period_comps apc
199: WHERE apc.time_recipient_id = p_time_recipient_id);

Line 203: FROM sys.dual

199: WHERE apc.time_recipient_id = p_time_recipient_id);
200:
201: CURSOR csr_chk_daru IS
202: SELECT 'Y'
203: FROM sys.dual
204: WHERE EXISTS (
205: SELECT 'x'
206: FROM hxc_data_app_rule_usages daru
207: WHERE daru.time_recipient_id = p_time_recipient_id);

Line 211: FROM sys.dual

207: WHERE daru.time_recipient_id = p_time_recipient_id);
208:
209: CURSOR csr_chk_ac IS
210: SELECT 'Y'
211: FROM sys.dual
212: WHERE EXISTS (
213: SELECT 'x'
214: FROM hxc_approval_comps ac
215: WHERE ac.time_recipient_id = p_time_recipient_id);

Line 219: FROM sys.dual

215: WHERE ac.time_recipient_id = p_time_recipient_id);
216:
217: CURSOR csr_chk_asc IS
218: SELECT 'Y'
219: FROM sys.dual
220: WHERE EXISTS (
221: SELECT 'x'
222: FROM hxc_application_set_comps_v appsc
223: WHERE appsc.time_recipient_id = p_time_recipient_id);