[Home] [Help]
375: CURSOR c_cust_addr IS
376: select td.tp_detail_id,
377: nvl(td.edi_flag,'N')
378: from ece_tp_details td,
379: hz_cust_acct_sites_all ra
380: where td.translator_code = l_translator_code and
381: ra.ece_tp_location_code = l_location_code and
382: ra.tp_header_id = td.tp_header_id and
383: td.document_id = p_transaction_type and