1902: DM with the same trx_number and same batch source */
1903:
1904: SELECT decode ( max(dummy), NULL, 'N','Y')
1905: INTO l_does_it_exist 1906: from dual 1907: where exists (select trx_number from
1908: ra_customer_trx, ra_cust_trx_types
1909: where trx_number = l_ct_rec.trx_number
1910: and batch_source_id = l_ct_rec.batch_source_id
[Home] [Help]