[Home] [Help]
476: SELECT distinct 'Y'
477: INTO l_batches
478: FROM ar_trans_field_formats
479: WHERE transmission_format_id = (SELECT transmission_format_id
480: FROM ar_transmission_formats a,
481: ar_transmissions_all b
482: WHERE a.transmission_format_id = b.requested_trans_format_id
483: AND b.transmission_request_id = in_trans_req_id )
484: AND field_type_lookup_code = 'BATCH NAME';