The following lines contain the word 'select', 'insert', 'update' or 'delete':
Line: 93
SELECT MAX(AVPFPV.accounting_date)
INTO lc_closing_date
FROM ap_view_prepays_fr_prepay_v AVPFPV
WHERE AVPFPV.prepay_id= prepay_inv_num
AND AVPFPV.prepay_line_number= prepay_line_number_param ;