1415: WHERE organization_id = p_organization_id
1416: AND location_id = p_location_id;
1417: CURSOR register_balance_cur(p_organization_id NUMBER,p_location_id NUMBER) IS
1418: SELECT register_balance
1419: FROM JAI_OM_OE_BOND_TRXS
1420: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1421: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1422: WHERE A.register_id = B.register_id
1423: AND B.organization_id = p_organization_id
1417: CURSOR register_balance_cur(p_organization_id NUMBER,p_location_id NUMBER) IS
1418: SELECT register_balance
1419: FROM JAI_OM_OE_BOND_TRXS
1420: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1421: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1422: WHERE A.register_id = B.register_id
1423: AND B.organization_id = p_organization_id
1424: AND B.location_id = p_location_id );
1425: CURSOR Get_Tax_Lines_Details_Cur1 IS