APPS.ARP_PROCESS_RCTS dependencies on DUAL

Line 941: FROM dual

937: /* Added CC chargeback -ve misc receipt too for this condition */
938:
939: SELECT 1
940: INTO l_dummy
941: FROM dual
942: WHERE
943: EXISTS
944: ( SELECT 1
945: FROM AR_CASH_RECEIPT_HISTORY crh, ar_receivable_applications ra

Line 1097: FROM dual

1093: END IF;
1094:
1095: SELECT decode ( max(dummy), NULL, 'N','Y')
1096: INTO l_posted_flag
1097: FROM dual
1098: WHERE EXISTS
1099: (SELECT 'posted distribution exists'
1100: FROM ar_cash_receipt_history
1101: WHERE cash_receipt_id = p_cash_receipt_id