APPS.HXC_EGC_BUS dependencies on DUAL

Line 285: FROM sys.dual

281: -- cursor to check time_entry_rule_id is valid
282: --
283: CURSOR csr_chk_ter IS
284: SELECT 'error'
285: FROM sys.dual
286: WHERE NOT EXISTS (
287: SELECT 'x'
288: FROM hxc_time_entry_rules ter
289: WHERE ter.time_entry_rule_id = p_entity_id );

Line 293: FROM dual

289: WHERE ter.time_entry_rule_id = p_entity_id );
290:
291: CURSOR csr_chk_tr IS
292: SELECT 'error'
293: FROM dual
294: WHERE NOT EXISTS (
295: SELECT 'x'
296: FROM hxc_time_recipients tr
297: WHERE tr.time_recipient_id = p_entity_id );

Line 301: FROM dual

297: WHERE tr.time_recipient_id = p_entity_id );
298:
299: CURSOR csr_chk_rr IS
300: SELECT 'error'
301: FROM dual
302: WHERE NOT EXISTS (
303: SELECT 'x'
304: FROM hxc_retrieval_rules rr
305: WHERE rr.retrieval_rule_id = p_entity_id );

Line 309: FROM dual

305: WHERE rr.retrieval_rule_id = p_entity_id );
306:
307: CURSOR csr_chk_ptg IS
308: SELECT 'error'
309: FROM dual
310: WHERE NOT EXISTS (
311: SELECT 'x'
312: FROM hxc_template_summary hts
313: WHERE hts.template_id = p_entity_id

Line 449: FROM sys.dual

445: -- cursor to check entity group id is valid
446: --
447: CURSOR csr_chk_egc IS
448: SELECT 'error'
449: FROM sys.dual
450: WHERE NOT EXISTS (
451: SELECT 'x'
452: FROM hxc_entity_groups egc
453: WHERE egc.entity_group_id = p_entity_group_id );

Line 530: FROM sys.dual

526: -- cursor to check entity type is valid
527: --
528: CURSOR csr_chk_lkup IS
529: SELECT 'error'
530: FROM sys.dual
531: WHERE NOT EXISTS (
532: SELECT 'x'
533: FROM hr_lookups lk
534: WHERE lk.lookup_type = 'HXC_ENTITIES'