APPS.ARP_CORRECT_CC_ERRORS dependencies on DUAL

Line 213: FROM dual

209: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.cc_mapping_exist()+' );
210: END IF;
211: SELECT 'Y'
212: INTO l_return
213: FROM dual
214: WHERE EXISTS (SELECT 1
215: FROM ar_cc_error_mappings
216: WHERE cc_error_code = p_cc_error_code
217: AND cc_trx_category = p_cc_trx_category

Line 352: FROM dual

348: WHERE TRXN_EXTENSION_ID = p_payment_trxn_extension_id;
349:
350: SELECT 1
351: INTO l_dummy_number
352: FROM dual
353: WHERE NOT EXISTS ( SELECT 1
354: FROM ar_cc_error_history cc, iby_fndcpt_tx_extensions b
355: WHERE cc.cc_trx_id = p_cc_trx_id
356: AND cc.cc_trx_category = p_cc_trx_category

Line 1670: FROM dual

1666: IF p_mode = 'REMITTANCE' THEN
1667: BEGIN
1668: SELECT 'Y'
1669: INTO l_return_status
1670: FROM dual
1671: WHERE EXISTS (SELECT 1
1672: FROM ar_cash_receipts
1673: WHERE request_id IN ( select request_id
1674: from fnd_concurrent_requests

Line 1691: FROM dual

1687: ELSE
1688: BEGIN
1689: SELECT 'Y'
1690: INTO l_return_status
1691: FROM dual
1692: WHERE EXISTS (SELECT 1
1693: FROM ra_customer_trx
1694: WHERE request_id IN ( select request_id
1695: from fnd_concurrent_requests