404: AND fin_year = cp_fin_year);
405:
406: -- RG23D
407: CURSOR c_rg23d(cp_fin_year IN NUMBER) IS
408: SELECT register_id FROM JAI_CMN_RG_23D_TRXS
409: WHERE organization_id = p_organization_id
410: AND location_id = p_location_id
411: AND inventory_item_id = p_inventory_item_id
412: AND fin_year = cp_fin_year
409: WHERE organization_id = p_organization_id
410: AND location_id = p_location_id
411: AND inventory_item_id = p_inventory_item_id
412: AND fin_year = cp_fin_year
413: AND slno = (select max(slno) from JAI_CMN_RG_23D_TRXS
414: WHERE organization_id = p_organization_id
415: AND location_id = p_location_id
416: AND inventory_item_id = p_inventory_item_id
417: AND fin_year = cp_fin_year);