1655: WHERE organization_id = p_organization_id
1656: AND location_id = p_location_id;
1657: CURSOR register_balance_cur(p_organization_id NUMBER,p_location_id NUMBER) IS
1658: SELECT register_balance
1659: FROM JAI_OM_OE_BOND_TRXS
1660: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1661: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1662: WHERE A.register_id = B.register_id
1663: AND B.organization_id = p_organization_id
1657: CURSOR register_balance_cur(p_organization_id NUMBER,p_location_id NUMBER) IS
1658: SELECT register_balance
1659: FROM JAI_OM_OE_BOND_TRXS
1660: WHERE transaction_id = (SELECT MAX(A.transaction_id)
1661: FROM JAI_OM_OE_BOND_TRXS A, JAI_OM_OE_BOND_REG_HDRS B
1662: WHERE A.register_id = B.register_id
1663: AND B.organization_id = p_organization_id
1664: AND B.location_id = p_location_id );
1665: CURSOR Get_Tax_Lines_Details_Cur1 IS