[Home] [Help]
2035: CURSOR c_rg23d_details(p_register_id NUMBER) IS
2036: SELECT closing_balance_qty - opening_balance_qty receipt_quantity,
2037: Nvl(basic_ed, 0) + Nvl(additional_ed, 0) + Nvl(other_ed, 0) duty_amount,
2038: transaction_uom_code
2039: FROM JAI_CMN_RG_23D_TRXS
2040: WHERE register_id = p_register_id;
2041:
2042: CURSOR c_cess_details(p_register_id NUMBER) IS
2043: SELECT credit