311: dtl.last_update_login,
312: p_request_id
313: FROM zx_rep_trx_detail_t dtl
314: WHERE EXISTS (select distinct ah.invoice_id
315: FROM ap_holds_all ah
316: WHERE ah.invoice_id = dtl.trx_id
317: AND ah.release_lookup_code IS NULL )
318: AND dtl.request_id = p_request_id);
319: