204: dtl.last_update_login,
205: p_request_id
206: FROM zx_rep_trx_detail_t dtl
207: WHERE EXISTS (select distinct ah.invoice_id
208: FROM ap_holds_all ah
209: WHERE ah.invoice_id = dtl.trx_id
210: AND ah.release_lookup_code IS NULL )
211: AND dtl.request_id = p_request_id);
212: