[Home] [Help]
205: FOR duty_rec IN (SELECT rgd.excise_duty_rate,
206: rgd.rate_per_unit,
207: rgd.quantity_received
208: FROM JAI_CMN_RG_23D_TRXS rgd,
209: JAI_CMN_MATCH_RECEIPTS rm
210: WHERE rm.ref_line_id = v_delivery_detail_id
211: AND rgd.register_id = rm.receipt_id)
212: LOOP
213: v_excise_total := NVL(v_excise_total, 0) + NVL(duty_rec.excise_duty_rate, 0) *