425: AND fin_year = cp_fin_year);
426:
427: -- RG23D
428: CURSOR c_rg23d(cp_fin_year IN NUMBER) IS
429: SELECT register_id FROM JAI_CMN_RG_23D_TRXS
430: WHERE organization_id = p_organization_id
431: AND location_id = p_location_id
432: AND inventory_item_id = p_inventory_item_id
433: AND fin_year = cp_fin_year
430: WHERE organization_id = p_organization_id
431: AND location_id = p_location_id
432: AND inventory_item_id = p_inventory_item_id
433: AND fin_year = cp_fin_year
434: AND slno = (select max(slno) from JAI_CMN_RG_23D_TRXS
435: WHERE organization_id = p_organization_id
436: AND location_id = p_location_id
437: AND inventory_item_id = p_inventory_item_id
438: AND fin_year = cp_fin_year);