[Home] [Help]
187: FOR duty_rec IN (SELECT rgd.excise_duty_rate,
188: rgd.rate_per_unit,
189: rgd.quantity_received
190: FROM JAI_CMN_RG_23D_TRXS rgd,
191: JAI_CMN_MATCH_RECEIPTS rm
192: WHERE rm.ref_line_id = v_delivery_detail_id
193: AND rgd.register_id = rm.receipt_id)
194: LOOP
195: v_excise_total := NVL(v_excise_total, 0) + NVL(duty_rec.excise_duty_rate, 0) *