APPS.ARP_PROCESS_RCTS dependencies on DUAL

Line 994: FROM dual

990: /* Added CC chargeback -ve misc receipt too for this condition */
991:
992: SELECT 1
993: INTO l_dummy
994: FROM dual
995: WHERE
996: EXISTS
997: ( SELECT 1
998: FROM AR_CASH_RECEIPT_HISTORY crh, ar_receivable_applications ra

Line 1150: FROM dual

1146: END IF;
1147:
1148: SELECT decode ( max(dummy), NULL, 'N','Y')
1149: INTO l_posted_flag
1150: FROM dual
1151: WHERE EXISTS
1152: (SELECT 'posted distribution exists'
1153: FROM ar_cash_receipt_history
1154: WHERE cash_receipt_id = p_cash_receipt_id