DBA Data[Home] [Help]

APPS.ARP_RECONCILE dependencies on DUAL

Line 345: from dual

341:
342: BEGIN
343: select 'Y'
344: into l_def_flag
345: from dual
346: where exists (select 'x'
347: from ra_cust_trx_line_gl_dist gld
348: where gld.account_class = 'TAX'
349: and gld.customer_trx_id = p_customer_trx_id

Line 1052: from dual

1048: END IF;
1049:
1050: select 'N'
1051: into p_all_br_closed
1052: from dual
1053: where exists ( select /*+ ordered leading(rc.rct) use_nl(rc.rct ps)*/ 'x'
1054: from ( select customer_trx_id
1055: from ra_customer_trx_lines rct
1056: start with br_ref_customer_trx_id = p_customer_trx_id