DBA Data[Home] [Help]

APPS.JAI_GENERAL_PKG dependencies on JAI_CMN_RG_23D_TRXS

Line 408: SELECT register_id FROM JAI_CMN_RG_23D_TRXS

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

Line 413: AND slno = (select max(slno) 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
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);