[Home] [Help]
491: SELECT distinct 'Y'
492: INTO l_batches
493: FROM ar_trans_field_formats
494: WHERE transmission_format_id = (SELECT transmission_format_id
495: FROM ar_transmission_formats a,
496: ar_transmissions_all b
497: WHERE a.transmission_format_id = b.requested_trans_format_id
498: AND b.transmission_request_id = in_trans_req_id )
499: AND field_type_lookup_code = 'BATCH NAME';