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 345: FROM dual

341: -- Check if subsequent action code already performed on this entity
342: BEGIN
343: SELECT 1
344: INTO l_dummy_number
345: FROM dual
346: WHERE NOT EXISTS ( SELECT 1
347: FROM ar_cc_error_history
348: WHERE cc_trx_id = p_cc_trx_id
349: AND cc_trx_category = p_cc_trx_category

Line 1665: FROM dual

1661: IF p_mode = 'REMITTANCE' THEN
1662: BEGIN
1663: SELECT 'Y'
1664: INTO l_return_status
1665: FROM dual
1666: WHERE EXISTS (SELECT 1
1667: FROM ar_cash_receipts
1668: WHERE request_id = p_request_id
1669: AND cc_error_flag = 'Y');

Line 1683: FROM dual

1679: ELSE
1680: BEGIN
1681: SELECT 'Y'
1682: INTO l_return_status
1683: FROM dual
1684: WHERE EXISTS (SELECT 1
1685: FROM ra_customer_trx
1686: WHERE request_id = p_request_id
1687: AND cc_error_flag = 'Y');